I am looking to open a selection of spreadsheets, select the same cells from each worksheet and paste them into a table in a new spreadsheet.

So filename iain range("B3") is pasted into filename iaintable range("A1"), followed by filename iain123 range("B3") pasted into filename iaintablerange("A2").

I'm looking to do this as part of a loop, can I set dim range "A1" as, say abc, and then past into range("abc") followed by range("abc + 1") etc, or is there a better way to do this!?

Iain