Hi, I have 12 worksheets of data in one workbook.
I need to copy, paste special, values these all to another empty sheet.

Each sheet needs to start where the last one finished - ie. sheet 1 has 1300
rows of data so sheet 2 should copy after it from row 1301.

I know of course I can do this manually by copying and pasting each sheet
one at a time but is there an excel tool that can do this?
I dont know macro programming and I cant use macro recording because the
number of rows changes in each of the 12 sheets every month.

thanks to anyone that can help relieve me of this laborious task!
Rob
--
Rob Gaffney