I want in one worksheet to relatively link to/reference cells in another without changing the format of the current worksheet.
 

Hi,

I want in one worksheet to relatively link to/reference cells in
another without changing the format of the current worksheet. I.e. I'm
working on a budget. In "sheet 1" I want to view the employees and
their billable hours sorted by the teams the employees belong to. I
want each employees row/info to be linked to "sheet 2", where it
contains all the same info, but the sort is by employee position, not
team.

In otherwords I only want to enter information into the sheet sorted by
position, and have the sheet by team automatically pick it up. I also
want the ability to sort position sheet by other ways, but have the
sheet 1 maintain the references and format.

Hopefully this makes sense.

Thanks,

Aaron