Consider not deleting the old sheets and replacing with new sheets. How
about just refreshing the data in the sheets with data from the most recent
sheets.


(import the data, not the sheets)


--
Gary''s Student - gsnu200785


"Brennan" wrote:

I have a macro that deletes old sheets from a master workbook and imports the
new sheets containing the updated information. In the master workbook, I
have links to each sheet and when they are delete the old sheets, the link
goes away as well. The new sheets are in the exactly the same format so if
the previous links did work, it would pull the right information. Is there a
way (other than using code to reset the links) to keep the links active as
sheets delete and are replaced?

Thanks for your help!

Brennan