Multi-tab spreadsheet - autofill column possibility?

[Ksilva]

Hi there,

I have a multi-tab spreadsheet where raw data is dumped in a "data sheet" tab on a weekly basis. This data is pulled into the "main view" tab. I'd like the "main view" tab to always reflect the same data in the first column as the first column of the raw data tab. Initially I set it up as ='Data Sheet'!A2, etc all the way down but this spreadsheet gets sorted often and the rows on the raw data tab can sometimes be longer/shorter than they were the previous week. As a result some data gets missed unless I always double check and drag it.

I'm wondering if there's a more efficient way to do this so that the first column in the main view can always equal the first column of the raw data tab despite sorting fluctuations.

Thanks in advance.

 

[sadboy309]

I propose the function Indirect() for this case.
For example:

[main view!A1]=INDIRECT("'data sheet'!A" & row())

 

[Ksilva]

I propose the function Indirect() for this case.
For example:

Thank you for your response. This is the error I received when trying this:

This is what I wrote verbatim in A2 of the Main View tab:
=Indirect("'Data sheet'!A'" & row(2))

I must have done something wrong but am unfamiliar with Indirect. Thanks!

 

[sadboy309]

You copy this function:

=INDIRECT("'Data sheet'!A" & ROW())

 

[Ksilva]

Thank you - the only issue here is now I can’t sort. Any other ideas?