Multiple Sheets in an Excel File---Each according to last name

[AgeOfEgos]

Hello, new here and glad to find the board .

I'm creating a spreadsheet that will have several sheets within. The first sheet will have every customer in it, sorted by a customer ID #. So far so good.

However, I want to create multiple sheets in addition to the first one----each one being unique to the customer's last name. So;

Master Sheet
Sheet 2 would be "Customers that start with A"
Sheet 3 would be "Customers that start with B"
etc.


I figured out how to link the column from the Master Sheet (Sheet 1) and paste special/link in the other sheets---so when a customer is added to the Master it updates the other sheets. However, I can't figure out how to make the sheet ONLY show customers from the Master that start with a specific last name. Any help and thanks again!

[royUK]

That's a really bad design idea, you could potentially end up with dozens of sheets.

All data should be on one sheet then use PivotTables, etc to analyse the data by customer