Hi,

There are total 20 location files which contain 6 tabs out of which I need the last 3 tabs i.e. sheet4,sheet5 & sheet6 to copy into my macro file.The name format for those three tabs are same in all 20 locations.

ex - sheet4 = "Input_location" (location will change according to the location e.g for mumbai it will be Input_mumbai)
sheet5 = "content_location"
sheet6 = "summary_location"

I don't want to use the tab names in my macro instead I want to use codename of the tabs.

please suggest something how to use it?