Hi. I am working on a spreadsheet that has Pivot Tables where the Supervisors can filter for dates and refresh data. I need help in getting all 117 supervisors to remember to choose the most current date and THEN refresh the data! What I need is a formula that will automatically pull the data for the previous day and include the past 30 days when the Supervisors click refresh data. Is that possible? Also, there are 4 sheets to the worksheet. I know I can link the fields on one sheet so when I choose a Supervisor's name it will automatically choose the same name for multiple cells, but can I link other cells from the other 3 sheets so the name chosen also?