I am a novice - please help.

I have two ranges to be copied into one worksheet but I can’t specify the exact ranges because additional rows maybe added.
Additionally, after the range is copied into Sheet1 from Sheet2 then macro should look for the last line in Sheet1 and copy more data from Sheet3 and so on.

Thanks for your help!