I have about 30 different workbooks that we update monthly for financial
closing. We want to create one workbook that combines certain sheets from
each of those 30 books, change their tab names and send to the executive team
for monthly reporting. We have figured out that we can run a macro to do
that but it keeps getting hung up at the prompts for updating linked
workbooks and like named tabs. Any suggestions?