I have a workbook with one starting sheet named "master data".

After this sheet, there is a variable amount of sheets containing
data.

I would like to run the following macro to capture the data i need
from each sheet and paste to the master data sheet starting at row 10.
each paste should be subsequent to the previous paste.


Rows("10:10").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Copy