Paste data into first blank cell after a specific row

[lwebbie]

I have a worksheet that has a 7 row header (some rows are blank). I am copying data from 3 different tables and need to paste it into the first blank cell after row 7. One thing to note is I also need to be able to specify the column to paste into as the data in the table isn't in the same orders as the spreadsheet it is being pasted on.

(i.e. I am copying ListObjects("Table24").ListColumns(8).DataBodyRange.Copy and need to paste that data into column B on my worksheet)

THANKS!