I am pretty experienced with Excel in general, but new to VBA programming.

I need to create one consolidated list of data, by combining all data from two separate worksheets (called "Wk1-Data" and "Wk2-Data") into a third worksheet (called "All Data"). All sheets are in the same workbook.

All three worksheets have a the same number of columns (A thru G) with identical column headings, but all sheets will have a variable number of rows of data vs the last time the macro was run.

My challenge is dealing with the variable number rows of data in the source sheets, as that requires a variable range to be selected for copying, as well as, a variable paste location within destination sheet ("All Data") when pasting the second set of data.

I figured out how to deal with the variable range in the source sheets for copying by using CurrentRegion.Copy, however, I cannot seem to figure out how to find to paste the second set of data at the bottom of the first set of data, since that paste location will be a variable dependent upon how many rows were in the first data set.

I have recorded the following macro that selects all the data from sheet1 (using CurrentRegion.Copy) and pastes it into the active sheet "All Data".

Sub Combine_All_Data()
'
    Sheets("Wk1-Data").Select
    Range("a1").CurrentRegion.Copy Sheets("All Data").Range("a1")
    
End Sub
I need to modify this to add code that will copy all the data from "Wk2-Data" and paste it at the first blank row below the week 1 data that was already pasted into the "All Data" worksheet.

I know I can grab the variable range of data the same way I did for Wk1-Data using:

 Sheets("Wk2-Data").Select
    Range("A1").CurrentRegion.Copy Sheets("All Data Combined").Range([need code for variable range location here??])
... but, again, I do not know how to specify the variable range destination for the paste location at the bottom of the week 1 data after it has been pasted inside "All Data".

Many thanks for any solution that anyone can provide!! I suspect it will be very easy for the gurus out there!

Z