Selected Answer
I made some changes to your workbook. In particular, I removed the blank second line and I moved some of the hidden blank columns to a location before the club name column. I also added one such blank, hidden column because I needed an identical column count for each set of columns and one seemed to be missing.
Please look for this enumeration at the top of the code sheet called TXL_4326.
NspAnchorClm = 2 ' 2 = column B
NspTblClmCount = 5 ' number of Table Columns
NspCapsRow = 2 ' captions row
NspFirstDataRow ' next after captions row
It's the value for NspTblClmCount which must be kept in synch with the reality on the sheet. Currently there are 5 columns per set, 2 of them hidden, which doesn't matter. If you delete them, delete them in all sets, or add more, but adjust the enumeration to show the correct number of columns per set.
You can add columns outside the sets on the left of column B. That column is identified as NspAnchorClm and now has a value of 2, meaning your first column set starts in column B. All other addresses are calculated from there using NspTblClmCount.
Most of the code is in the standard code module TXL_4326. Dragging it between VBA projects in the VB Editor's Project Explorer pane will create copies, not move the modules. That's convenient for transferring code between projects, such as from mine to yours. Unfortunately, this easy method isn't available for code in worksheet code modules. The code in the code module marked Sheet1 (Week 1) in the Project Explorer has to be transferred using copy and paste. This code is identical on all the sheets. The program makes copies of it automatically as new sheets are added by it.
The way to add a sheet is to double-click on the blue arrow on the right of the top row. This will fire up the event procedure in the worksheet's code module which activates the code in the module TXL_4326 which removes all rows with club names marked red and writes the remainder into a new sheet. I didn't change the ID numbers you had in each row.
It's quite a little project and I didn't have the time to test it all. I suggest you start by reading through the comments and then run about 62 tests. Whatever errors you find, let me know about them and I shall try to get them fixed pronto.