Link between two sheets where filter doesn't mess up the link

[shala]

Hi. I'm trying to link between two sheets. There are filters on both sheets.

Sheet1 A1 has the data: Cheetah
Sheet2 A1 is linked to Sheet1 A1 using the formula 'Sheet1'!A1
This works well until I use the filter to sort Sheet1. Then, the value on Sheet2 A1 now shows the data on Sheet1 A1 instead of following the Cheetah value.

Is there a formula that I can use instead where Sheet2 A1 still says Cheetah even though filters are used?

I tried using VLOOKUP but the same issue comes up.

Thanks for your help!

 

[Yongle]

Try using 3 sheets
sheet1 with data without any filters
sheet2 (with formula =Sheet1!A1) - filter & sort in this sheet
sheet3 (with formula =Sheet1!A1) - filter & sort in this sheet