I am looking to export 1000+ sheets in a workbook into a separate workbook each. I would like to retain the links however from the main tab that links to each one of these sheets. This is housed on a server as well so I would need to use the location there. All new sheets would be housed in the same location. Hopefully with the example below this will be clear. I also have no idea if retaining the links is possible.


Workbook.xlsm- made up of the below
Main_Tab- holds numerous formulas and links to certain cells in all the sheets below.
A-sheet needs exported with name 'A.xlsx"
B-sheet needs exported with name 'B.xlsx"
C-sheet needs exported with name 'C.xlsx"
D-sheet needs exported with name 'D.xlsx"
E-sheet needs exported with name 'E.xlsx"
F-sheet needs exported with name 'F.xlsx"
G-sheet needs exported with name 'G.xlsx"
etc............