The scenario is I have 15 sheets named "MAP_COMBINED" , "MAP_COMBINED (2)", "MAP_COMBINED (3)", "MAP_COMBINED (4)"...............to , "MAP_COMBINED (15)".
I am not really good at VBA Coding and I wonder if it is really possible to have a MACRO to simultaneously copy and move them into one worksheet together with a Dialog box/Pop up input box ="NAME" of the new worksheet and rename the (15) sheets based on its cell value on BT3?
Thank you!
Bookmarks