How to create link of DATA not cell reference in Excel?
 

Here Goes...long story short, I am trying to make Excel work a little like
Access. I have a 'main' worksheet with data. Additional worksheets/tabs
have links of the data on the 'main' tab.

However...when I delete or add a row, or resort the data on the 'main' tab,
the linked data continues to reference the ROW/COLUMN instead of the DATA and
the links are therefore useless to me.

Can a formula be used where the DATA is linked rather than the R/C, so that
when the 'main' worksheet/tab is updated, the linked worksheets are updated
correctly?

Thanks for your suggestions!