I need help!! need to summarized weekly sales

[cteq1]

I have weekly sales worksheet with daily sales, discounts, costs etc. What I would like to do is produce one work sheet that will import weekly numbers, so I can analyse, chart produce monthly tax etc. automatically.

I am stuck on how to import those numbers from other worksheets automatically. I know I can do so manually but there has to be better way.

I just finished watching Excel Advance tutorial where I picked up some tips but couldnt find a way to solve my problem.

My files are 3569 011109.xls
next one 3569 011809.xls
next one 3569 012509.xls

I need to pick net 2 sales, net 3 sales, sales tx, transactions, labor, food cost, paper cost, discount etc. on a new spreadsheet so I can analyze, chart graphs, sales vs prev years, prev months etc.

I am attaching link to where sample of the files can be downloaded.

http://rapidshare.com/files/270709911/greenbook_2009.zip

 

[cteq1]

Looks like this may not be possible, as I have no responses. I was wondering if I can import this in access and then try it?