What is the most efficient way to copy, paste and transpose values between worksheets?

Originally Posted by AB33

It can be done, but need clarification.
The Uk heading starting at the top goes all the way down.

Yes, I would like the macro to collect all the ranges. PS. "Uke" means week

Originally Posted by AB33

When you say transpose, do all the data go on the same sheet in sequence. You have three sheets, so I do not know what would be the relevant of these sheets.

Yes, all on the same page. In my macro above, I put all of them in Sheet(2)

Thank you for your time!