How to link two different worksheets together in Excel
 

I have a few separate lists that I update frequently, they are different
named files. How can I update one and have the other do the same? Do they
have to be saved as one file with separate worksheets to do this?