Is it possible to link multiple separate Excel files to a single file in which titles/values/input data can be filled which will in-turn modify the connected files. i.e. Main Excel File:Name Entered Date entered in main will change all the names in the connecting files to match.
Solved by X. Y. in 18 mins