How to sort a spreadsheet with dropdown menus so that the data follows the new sort?

FYI I've been searching solutions to this issue all over the internet for the last hour in various forumns and how-to sites and tutorials on YouTube, I've tried all given solutions (which aren't many, they all seem to repeat each other), still not working.

THE SETUP:

I have a spreadsheet "Sheet 1" with a few different date columns: "Start", "Wave", "Due".

• Each row in the "Start" column contains one date manually entered of when a campaign started.
• Each row in the "Wave" column has a date that's either manually entered or has a date from a dropdown menu - all data for all dropdown menus is listed on "Sheet 2". This is because some campaigns only have one wave, ie one launch date, but some campaigns span months and have different waves throughout those months, so I need a dropdown to select which wave we're currently on, ie when is the upcoming new set of assets launching for that campaign.
• Each row in the "Due" column is a formula based on Wave data minus 30 days (ex: if Wave data is 9/30/2023, then Due result would be 9/1/2023).

On Sheet 2, I have Column A with campaign names that correspond to campaign names in Sheet 1, then Column B with the dates needed.

• Example: A1: product launch, B2: 9/1/2023, B3: 9/15/2023, B4: 10/1/2023
  • The source for data validation in the Wave column on Sheet 1 for the "product launch" row would then be ='Sheet 2'!$B$2:$B$4

Since the data in the Wave column changes based on picking new dates from the various dropdowns, that will change the data in the Due column, and whenever data is changed in the Wave column, I want to do a new sort in the Due column so that dates are sorted oldest to newest.

THE ISSUE:

Whenever I do a new sort for the Due column (or any column for that matter), the dropdowns and all their data in Wave column stay where they are, they do not move with the rest of the row. It may look like it at first because after the sort the date in the Wave row is what was last chosen, but if I were to click on that cell to change the date to a new date, it would either not be clickable because prior to the sort there was no dropdown there, or it would show the wrong set of dates because prior to the sort a different dropdown menu was there. If I click on the cell in Wave column where the row used to be, I can see the original set of dates that should be associated with that row.

WHAT I'VE TRIED:

1. Tried converting the date data for each campaign in Sheet 2 to a table.
2. Tried adding in columns to Sheet 1 for the dates so that each row has the dates it needs hidden.
   • example: If Wave is Column A, and Due is Column B, I added in 3 columns between the 2 so that Wave = A, Date 1 = B, Date 2 = C, Date 3 = D, Due = E. Then in my data validation source, a dropdown for A2 would be $B$2:$D$2.
3. Tried taking off the "$" from the source in data validation in the #2 example above, thinking maybe that was keeping the dropdown data rooted to those cells.
4. Tried typing out the dates in the source box of data validation window.
   • example: instead of source looking like "$B$2:$D$2" it looks like "9/1/2023, 9/15/2023, 10/1/2023"

Please help! I'm at wits end with something that seems like it should be so simple, but it's become a huge issue and time waster.