Sorting Merged Cells in a Table

Hi,

I have tried to write a Macro to Sort Merged Cells (B16:B41,B48:B73) but unfortunately have failed.

I found a macro online which does this but only if the data starts in Cell A1. I have failed at modifying this for this table.

Unfortunately, I don't understand enough of VBA to do this myself yet.
Could someone help?

I am providing a link to the solution that I found online which works for data ranges that start in column A1 and a copy of the spreadsheet I am trying to sort.

https://excelribbon.tips.net/T000761...g_Merged_Cells

If you do figure this out, any notes on how to read your code would be greatly appreciated.

ps. before you ask, Unmerging the cells is not an option here.