I want to loop through 10 worksheets in my workbook (sheet1, sheet2...sheet10) and copy the data from A1 in each sheet and paste into column A in sheets("data"). Sheets("data") is part of the same workbook.

Many thanks in advance