Can I link and update between two excel files?

Use Power Query

Every time you update the source file, refresh the second file.