Hello all,

Here's the set up: I have a macro that when you run it, it creates a new tab with the next month on it. I.e. I'm in January 2014 and I hit the button it creates a tab for February 2014....

In a different workbook, I want to have it copy this newly created tab name into cell A1 of what we'll call Hidden_Tab.

So I want to have Hidden_tab A1 say January 2014, then I press the button to run the macro and it then copies the new tab name from the tab I just created: February 2014 and pastes it in Hidden_tab A1 and so on...

Any suggestions?

Thanks!!