Spreadsheet that consolidates info from multiple 'daily spreadsheets'

I have a business where we do a 'daily sales report' in excel and save each one in folders by month (example: Sales 2012>July>7-20-12.xls). I have a separate spreadsheet 'Consolidated Sales' that lists a variety of info from each of these daily reports.

The columns in the consolidated report correspond with rows in the daily reports such as; Food Sales, Credit Card Total, Cash, etc.

Each row on the consolidated report is for a different day, and so must look at the corresponding daily report to find its data. I am looking for a way to not have to manually update each cell on each line when I add another daily report that I want added to the consolidated list.

Is there a way that I can make/use a reference cell that would direct to the appropriate report/file, then have each cell in the row pull data from the corresponding cell as told?

Example: (Consolidated Report) for 7-20-12 (Row 1)

'Food' go to file "Sales 2012>July>7-20-12.xls" Cell B14

'Credit Cards' go to file "Sales 2012>July>7-20-12.xls" Cell B16

'Cash Deposit' go to file "Sales 2012>July>7-20-12.xls" Cell B20

Example: (Consolidated Report) for 7-21-12 (Row 2)

'Food' go to file "Sales 2012>July>7-21-12.xls" Cell B14

'Credit Cards' go to file "Sales 2012>July>7-21-12.xls" Cell B16

'Cash Deposit' go to file "Sales 2012>July>7-21-12.xls" Cell B20

Any help would be appreciated.

Thank you!

They are a little rough, but I have attached a sample of the consolidated report and an example of the daily report. Please let me know if you have any questions. Thank you in advance for taking the time to look at this!