Hi,

I have a spreadsheet that links data in from others.
I currently have a button with a macro assigned that updates the links when pressed.
Each new week, I have to edit the links to look at the next weekly sheets.
At present I have to manually edit the links in the macro also.
Could it be rewritten to update any links in the sheet, without having to specify each link in the macro, like an update all command?

Thanks for any assistance.