Combine selected data from multiple sheets

Hi,

I need to select n rows of data from specific columns and "stack" a copy of the data into the same columns in a new worksheet.

I've attached an example of what I'm trying to do for info.

There are different nos of rows in each worksheet and I'd like the macro to loop until it reaches the row containing no data

Can anyone start me off with the best way to achieve this please.

Thanks,

Louise