I have a macro that summaries data on sheet1, I then want it to append
this data in the form of a new row to the bottom of sheet2.

Is there a formula that I can use to locate the next blank row, or what
is the best way to achieve this please.