I have a workbook that has 3 worksheets in it. sheet one has an inflation
index. Sheet 2 is data entry for quotes. Sheet 3 is a duplicate of sheet 2
with the quote price inflated if a cell on Sheet 2 indicates to do so.

Sheet 2 and 3 can be autofiltered to view certain locations. If you are
going to auto filter sheet 2 to enter quotes only for a certain location(s),
then you will want to see only those same locations on sheet 3 inflated. Is
there any way to program the autofilter arrows so that if you filter sheet 2,
it performs the same filter on sheet 3 so that the user doesn't have to
repeat the steps?

Sheet 3 is all formulas, so there is no user intervention to sheet 3 at all
other than the fact that they have to re-filter.