I'm trying to write a macro that will select the last sheet, and copy its contents into a new sheet (to go at the end of the workbook). The Macro will also delete the first sheet in the workbook.

I can't seem to find code for selecting the first and last sheet in a series. I cannot use the sheet's name as the position of the sheets change every week.

I've been trying for ages but just can't get excel to understand what I'm trying to do. If anyone can help, I'd really appreciate it.

Chris