I have a Master Workbook that I have to update manually. Then I have many
users that have their own copy of the same file but with different names to
show users of the file. I need a function that will update their file (just
the one sheet, call it Final Data) from the master file.

This way they get the updated information without having to manually copy it
from the master. And I need it to do it automatically when they open their
copy of the file. Would prefer the user not have to run anything manually. It
can be behind the scenes, they unaware, or maybe a button that says update
now.

I tried doing the linking, but couldn't figure out how to link the entire
tab. The number of rows changes constantly, but the number of columns is
fixed. I have a row(#3) that has the drop down sorting buttons attached.

The reason for all this is that each user has there own limiting, sorting
preferences, but all the source data is the same.

Any assistance is greatly appreciated. I have been looking over all the
previous posts and none seem to do exactly what I need.