Hi,

Every week I have to move 25 different tables (each in a different sheet) all onto one master Table. I have a Macro that works, but it is the same code over and over for all 25 tables, so I'd like to learn how to use a variable to write the same function. Here's what I have currently (repeated 25 times) (Sorry, I don't know how to place code into one of those boxes)

Range("Table1").Copy
Sheets("AllData").Select
Range("A2").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Range("Table2").Copy
Sheets("AllData").Select
Range("A2").Select
Selection.End(xlDown).Select
Selection.Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False

So the first one pastes values into cell A2, then the second one (and all those following), selects Cell A2, jumps to the bottom row, then offsets one more row and pastes, then it selects the next table, and so on.

Here's what I think I'm supposed to start with, let me know if I'm on the right track!
Dim vAllDataTransfer As Variant
For Each ("Table1", "Table2", "etc")
With

thanks!