Combine data from many sheets into one Summary Sheet

Hi Guys,

I have a problem which I don't know even where to start. I think it might be a data table type issue, which if it is, then I am totally lost.

If I can explain what I am trying to do - I have two types of Point of Sales downloads into Excel which I am trying to summarise (for adding a dashboard to at a later stage):

1. A Daily Sales Report - which is a weekly summary of daily sales.
2. A Sales Report listing each staff members stats.

I would like to combine all the Daily Sales Reports onto a Summary sheet, but under one line of headings (i.e. like a consolidated table) and then, under this table (on the same sheet) another consolidated table with the staff members stats. In other words, on the Summary sheet there will be two table, one for Daily Sales & under that one for Staff Member stats.

I would also like to be able to add new data as the months go past by just adding new sheets in. I have attached a spreadsheet with the raw data on it - it doesn't yet have the summary sheet included.

Any ideas? Any suggestions for a dashboard would also be greatly appreciated.

Anyone got any ideas?