Hi All - I have a macro that's importing data from other Excel sheet only if the sheet name (Ex: Sheet1) is same as its referring in Macro (Sheet1), But the Sheet name is keep changing (Ex: Sheet4). Can anyone please share how to pick the name of the current tab on Source sheet (Source Excel) and use it in existing macro.

Sorry if the quesiton isn't clear enough.

Thanks in Advance,