VBA: Extract data from multiple spreadsheets

The following statement in a VBA macro with your values substituted for the "This" and "That" items below will copy from 1 book to another:

Workbooks(ThisBook).Sheets(ThisSheet).cells(ThisRow,ThisColumn).value = Workbooks(ThatBook).Sheets(ThatSheet).cells(ThatRow,ThatColumn).value

I will definitely try that.

Do you know how to loop through the spreadsheet names I have listed on the spreadsheet?

I just realized that you are referring to spreadsheets and not workbooks. Do you mean extracting data from several sheets within the same workbook or from several different workbooks?

I meant extracting from several different workbooks.

For example, if I have the following workbook names listed in cells A1, A2, and A3 of a spreadsheet.

A.xls
B.xls
C.xls

I want to loop through the three cells and open up each workbook using the name contained within each cell. Then I need to copy a range from each workbook and paste it into a common spreadsheet.

Here is my suggestion; others may prefer a different method:

Above the workbooks: Have a cell where you enter the folder name where the workbooks have to be read from, assuming they are all in the same folder (?)

Give that cell a range name of "FolderName".

Also above the workbooks - have a "header row" where you type something like "List of Workbooks". Name that cell "WkbksHeader".
Beneath the list of workbooks have a "footer row" where you type "End of List". Name that cell "WkbksEnd".

Your loop can be a For/Next: For NextBook = (Range("WkbksHeader").row + 1) to (Range("WkbksEnd").row - 1)

Each time through the loop, you get the next workbook name, append it to the foldername, which you read prior to the loop, and open the workbook. Do your cell copies and then close the workbook.

Hope this gets you started.