And the tool does exactly this! You paste your orders info into Table in rightmost sheet, and you get the new tournament info (rows which doesn't exist in tournament table jet) in 2nd sheet from left. I added comments in red shrift into every page, where is explained, for what the page/table is for!

Contrary what you did write, I couldn't identiyfy from where to read some info to be put into tournament table from orders table. So this part of info is missing currently, and you have either to add missing formulas yourself (the calculation steps are ordered from right page to left), or you have to give better information, from which columns of orders table this info must be read.