maintain cell references from Sheet1 in Sheets2-6, sort by different columns in Sheets2-6

Here's my situation:

Sheet1 contains my source data, sorted alphabetically by Name.

I want Sheet2 to use cell references from Sheet1, not the values.
Then I want to be able to sort Sheet2 by a different column.

None of these have worked:
* inserting a new sheet, then copying the data.
* inserting a new sheet, then look in Paste Special, but I don't see an option for cell references.
* Copying Sheet1.

Questions:
+ What commands do I need to use to make this happen?
+ Am I right that I need absolute references, not relative?

Thanks,

Nancy

As JeteMc pointed out, an example sheet might help. but if you are referencing a cell but then you want to be able to sort that data on a different sheet, have you tried INDIRECT?

Sorry for the delayed response.

I'm attaching part of the spreadsheet.

Name Sort is the data sheet. I want to automate the following:

1. Populate worksheets for different sorts (i.e. Division, Blooms) using the Name Sort cell references

2. Add or delete rows in Name Sort and have them appear or disappear from the other worksheets.
For example: Abba (row 3 on Name Sort) is Division 4 and Blooms 2 - early. If I delete the Abba row, I want it deleted on the Division & Blooms worksheets too.
Conversely, when I insert a new row to add a new bulb's information in Name Sort, I want it to show up sorted correctly in the Division & Blooms worksheets.

One other note:

I'm not familiar with many of Excel's commands, so please be patient with me ... My daughter created the drop downs at the top of each column, but I'm not sure if/how they can be used in this situation. She also suggested a Pivot Table, but I'm not very familiar with those either.

Thank you so much. This was what I was looking for, and there's no way I would have been able to make this happen without your help.

Guess I need to learn more about tables and when to use those vs. a regular worksheet.

Nancy