Macro or VBA to populate a master sheet

[politicalangel]

Hi,
I have over 200 workbooks / similar templates that I need data from to populate into a summary sheet.
So I need Cell C6 From referenced worksheets to populate. Does ayone have a macro to do so?
All the workbooks are labeled e.g
1-Jan/Store 1
1-Jan/Store 3
2- Feb/Store 10
2- Feb/Store 2
3-March/Store 200
an so on...
I need the data from this workbooks/worksheets that are in cell C6 to popluate across my rows on my summary sheet if the store is referenced

So in short a marco that will open the file, read the cell, and hardcode the amount into the summary sheet OR
an easy way to create a link for all the different workbooks that gives me the amount on tha cell

Please see attched for example...

Thank you in advance

 

[Luke M]

Check out Ron's tool here:
http://www.rondebruin.nl/win/s3/win024.htm

He also has several examples of looping through files within a folder, which you could combine to look at all 200 files.
http://www.rondebruin.nl/win/s3/win023.htm