Forum Discussion
Create a link between two Excel files
Trying to figure out how to resolve your situation with only a verbal description is well nigh impossible. I know your actual files contain real names and other identifiable information so they can't be shared. However, you'd be helping us help you if you could create a mockup of the real spreadsheets, using false names, and post those on OneDrive or GoogleDrive with a link pasted here that grants access.
Also let us know what version of Excel you're working with, or if you have a Microsoft 365 subscription. There are newer capabilities in that subscription or in the newest version of Excel, capabilities that might enable you to achieve the desired result without a macro. But, as noted, all of that would be easier to determine if you could post mockup samples of the actual workbooks.
https://1drv.ms/x/s!AlufqoyaYmiWkFL8zPuyRAmFpLcj?e=0EDNxl