I want to use a macro to copy data from the same cell in all worksheets and
then paste it row by row in the active worksheet.
I'm okay for the code to select and copy, I'm currently using an array
(don't know if there is a smarter way).
However could someone give me some pointers on the code to use for pasting
in the active sheet row by row. Without have to have a line of code for each
worksheet.
Cheers Laura