Hi,
I am a professional data analyst with hands on working experience primarily in excel and proficient in VBA, data cleansing, analysis and visual presentation.
I can separate the individual BOMs into separate sheets while at the same time removing existing links (assuming them to be hyperlinks) either manually or using macros.
However you would need to clarify what is to be done if any formulas or other such are found.
Looking forward to working with you.
Regards,
Sumod