How do I use the same BOM on multiple drawing files?

Has anyone tried to link a BOM to an external excel file, then use that same BOM in another drawing file while keeping everything linked to SW parts and assemblies? How well did it work? Especially when keeping bubble numbers straight.

I am using SW 2017.

SolidworksDrawings And Detailing