Hello,

I have a macro issue that another person who left my company wrote. In the current macro, data is being pulled from a tab called "Summary Sheet"

However, in the set of files (this is pulling from) the sheet has been renamed to "Report"


I do not want to rename several hundred tabs in different workbooks, so how would I tell the VBA code to pull the data from "Report" if it cannot locate tab "Summary Sheet" ?

Here is the code that references "Summary Sheet"


wbk2.Activate
Sheets("Report").Activate
Range("d30").Select
Application.CutCopyMode = False
Selection.Copy