I have a workbook with about 60 worksheets. I want to write a macro that
copies a column from each of these sheets and pastes it into a new sheet.
The only problem is the names of the worksheets will be changing frequently.
I know when I write macros they reference the actual sheet name and if this
changes the macro will no longer work. Is there anyway to reference the
sheet position, 1st sheet, 2nd sheet, etc. instead of the acual sheet names?

Thanks

Adam Bush