Cells linked across worksheets not linked after filtering

Hello,
Simple task I thought...

Two worksheets (within the same workbook).
Sheet 1 holds a large list of items with cost and retail prices.
The list is filtered to enable sorting by name, product number etc...

Sheet 2 is a nicer looking printable sheet holding a selection of these items with some images etc.
The information here is the same, however the prices are simple ='Sheet1'!A1 reference formulas.

This works fine, however the data in the linked cells is fixed, so when the first sheet is filtered and data moves to different rows, the references on the second sheet is all incorrect.
This also is the case when new data is added.

How do I ensure that the links on the second sheet 'stick' to the cells on the first when filtered or new data is added?

Many thanks

Would using references like =INDIRECT("'Sheet1'!A1") help?

Is the simple formula looking at a hidden row, when you want the result from the visible row in that position?