Hi all,

If possible, I need some help with the below:

Sheet 1 -

Main sheet with information for a number of groups. Contains numerous columns all with a filter to sort.

Sheet 2 -

Sub sheet with more detail than sheet one, broken down per group.

What I want is for the common data from Sheet 1 to automatically be updated on Sheet 2, when a change is made on Sheet 1.

At the moment I have a simple formula ='Sheet 1'!B5 and have also tried ='Sheet 1'!$B$5.

The problem I have is that when Sheet 1 is filtered into a different order, the data in Sheet 2 changes in line with the table.

I need Sheet 2 to follow the changes that are happening on Sheet 1 e.g. Sheet 1 B5 moves to Sheet 1 B20. I want Sheet 2 to now return the data in ='Sheet 1'!B20....

Is this possible?