Adding info from different Sheets into a master Sheet

[1tripz1]

Hi All, need to be pointed in the right direction on how to get this set up.

Basic functionality.

I will be adding a weekly report to each sheet, which will have varying rows within it, but always the same column headers.

I want a master sheet that will automatically pull all the rows of data through from each sheet, create a new row if needed but merge rows with the same data name and combine the figures.

Little hard to explain, so I've attached a basic example.

Thanks,

Chris

[Pauleyb]

I see you posted this in the New Users/Basics section, but what you request (combining data from multiple sheets) is not as easy as it sounds. In fact, I would say a database may be a better solution for you.
However, if you wish to use Excel, then I would say a Pivot table is the solution (which is not a Basic technique). Instead of spreading data across sheets (which I would just about always advise against) put all of your data in one sheet.
Next, make that one sheet a 'Table' by selecting a cell in it and typing Ctrl-T. This will allow you to use a Named Range when you create the pivot table, which will let you avoid having to change the pivot table reference every time you add data.
Highlight your table and then 'Insert Pivot Table'. This should say 'Table1' in the Table/Range input in the dialog box that shows up; also, choose new worksheet.
Set up your pivot table as you show in your example. I have updated your file and attached it.
Now here is a little gotcha - whenever you add new data the table should grow (you can confirm that by seeing the alternating line colors for the entire table), but the pivot table needs to be refreshed. Select a cell in the pivot table, and you should now have some 'Pivot Table Tools' ribbons appear. Select the Options ribbon, and then click on the Refresh icon. That should now include your new data.

[1tripz1]

Thanks Pauly, didn't even think of using a pivot table. This has answered my question and I've been able to create the SS I needed! Cheers!