I should mention that there are also SCRD2, HCD1, HCD2, HCD3 in the list for both the qualifiers, semi, and finals.

Sorry if I am vague here, but I sort of get what you trying to do...but could you map out what your target is and what you what form the end result? I.e. how do you want the outcome to be if it worked perfectly?
If you format it in a spreadsheet as to how you want it to look like in the spreadsheet (without formulas or magic tricks) or notepad to show what the outcome you want. Do it manually and the figure out what tools and formulas there is to bring it to how you want it.

It appears there will be some cross references to the different cells and finding that sweet formula that provides the outcome you want. I have often done this when someone has provided me a sheet with formulas in it and I reverse engineer how they have come up with the result.

I may not be the one to help you, but I am also taking on a challenge to see if I could nut it out with you. No doubt there are the experts here that will understand it and give you an answer, I am looking forwards to that too.
I am watching with baited eyes to see the results or work it out first.

Regards from Norfolk Island.

I have a list of about 120 bowlers. They bowl a 4 game qualifier, then the top 8 bowlers go head-to-head for one game. The winners of the head-to-head (SCRD1-SEMI, which is game 5, but shows up in my report under game 1) then bowl in a step-ladder format (SCRD1-FINAL), so they may have scores for games 6 or 7 or 8, which show up in my report under game 1, 2, or 3

First of all - why are there more games in the Final than there are in the Semi Finals?
I feel those two rows need to be reordered.

I would use the ToRow function for this (see screenshot).

Yes, Kevin, you are correct. When I was making the mockup, I reversed the labels for SCRD1-SEMI AND SCRD1-FINALS. SEMI should only have the one game and FINAL has the 3 games.

Here was my thought process. Separate all of the qualifying games, semi games and finals, then combine them by pulling the scores from the respective sheets. I added a column to combine event&usbc# because I need it to pull the scratch semi and final games to the scratch entry and the handicap semi and finals games to the handicap entry. Some bowlers bowl in both events.

I pull the information from the tournament software, put it in the correct column order and paste it into the first tab called Roster. That automatically spill the information into the qual, semi, and final tabs. Where I am having trouble is getting the combine tab, for the semi's game 5, and the finals games 6-8. I tried to use the xlookup function to look for the combo of the event & usbc# and return the score from that sheet. It is not working...

I admit that this is over my skill level as I am 63 and have not worked alot with spreadsheets over the past 30 years. I know enough to ask for help!

Nevermind. I figured it out myself.