Excel print problem

bingo_bango

Say I have a book which contains 23 worksheets (alphabetic splits) with 6 columns in each. I also have a separate worksheet which is set up as a printable doc.
If I want to have only four fields from the last row on a particular sheet populate the fileds on the printable doc, what's the easiest way?

e.g. on worksheet 'M', I want the row I have just filled ,A29-F29, to have a print option (perhaps as a button in a seventh column?), which will auto populate the fields in the printable sheet with four cells, A29, B29, C29 & E29, but ignore all other info on the rest of the sheets?
I was working along the lines of a mail merge, and can populate the cells in the print version, but only if I tell it which fields to use.
I need to have a one click option to populate with the latest info only. There will only ever be one addition to the book at a time.

All thoughts appreciated.

Troubleatmill_2

Macros?
One macro for each worksheet?