Excel and typing project

Tallying file (No macros) I need someone to show me how to create a spreadsheet that allows me to have a list that takes the data from the blue cells and creates one with the yellow cells. You will not know the Title_2 info beforehand and it should still work. Comparison file (no macros) In this XL file, there are 3 tabs, 1, 2, and combined. In tab1, I have highlighted the cells blue. In tab2, I have highlighted the cells yellow. In the combined tab, I want to put the data from tabs 1 and 2 in it. I also want the cells to retain the color so that when I manipulate the data I can see by color where it came from. Currently, if I do a cell reference I get the data but not the color. Presentation_1 I need someone to type all the file names into a txt document.