First of all I am a macro newbie so please be gentle with me if you are kind
enough to respond.

I have 5 cells of data in a spreadsheet that I want to copy to a separate
spreadsheet, appending the existing data table. Can this be done with a macro?