linking & sorting worksheets; adding deleting rows/columns in file update

Hi,

Semi-newbie questions:

My workbook has data about garden bulbs - 11 columns, 100+ rows; Sheet 1 = data sorted by Name.

I have 5 additional worksheets, each sorted by a different column (color, height, etc.). I created these by doing each sort on Sheet 1, then copying & renaming the new worksheets. I know creating cell references was a better way to go, but I'm not sure which kind of reference I need, nor the best way to make that happen. I also don't know how to tell each sheet to sort on its own column. Help please!

After I get that done with the existing data, I want to do a 2021 update, adding new rows and deleting others. What will happen on Sheets 2-5 when I make changes on Sheet 1? Is there anything else I will need to do to make it work or will it all happen automatically?

Thanks,

Nancy

Since I've had no responses, I asked someone I know if there's a way to get what I'm looking for. She showed me an easy way to accomplish this.

On sheet1, create filter drop-downs for each column, then do the particular sort I want. I can then print that sort if I need to.
No need for additional worksheets!

Easy peasy!

Nancy