I am looking to create a summary table in one spreadsheet, by copying information from all spreadsheets in a file.

So I am looking to open all spreadsheets (the titles are random and therefore I can't specify) from a folder g:\Iain, and then copy particular cells into my summary table.

E.g open spreadsheet in G:\Iain, copy cell B3 and paste into cell A1 of summary table spreadsheet in folder F:\Table.

I want to go through all spreadsheets in G:\Iain and copy the same cells, but paste below the previous results in results table spreadsheet (e.g. the second spreadsheet opened, I want to copy cell B3 as before, but paste into cell A2 in my table spreadsheet and so on.

I am pretty new to VBA so please bear with me.

I think I may be able to use loops but am unsure as to the "unknown" element of the titles and pasting into next line.

Any help would be appreciated!

haddy27