I've got a workbook I'm trying to create. On the main page it's the full
version of all the data. On the tabs following is the data sorted out by
"Owner" meaning each owner has their own worksheet. I created the worksheets
by using the Auto-filter to sort by owner and copying/paste special/Links. I
want the owner worksheets to be password protected so that all the
information is updated when someone updates the main page. The only problem
is that we need to be able to do different "sorts" from the info on the main
page, and when the main page is sorted, it screws up all the links on the
following owner-worksheets.

I don't know anything much about VBA or functions, but I know there's got to
be a way to do this and I'm having a hard time figuring it out.

Can anyone help?

TIA!