I am trying to create a workbook where I can have report tabs that feed from the master worksheet. All data is entered into the master worksheet daily. The formal I used ='Master '!A1 this worked fine the first time. But I use Auto filter on the master sheet and this mixed everything up. The only solution I can think of is to do it again completely and then manually insert $ into 1400 fields to lock it, I am sure there is a better way

Hopefully someone can steer me into the right direction

thank you