To answer your questions:
While I am not new to programming, I am very new to VBA, which next to no one on the team has experience in. While I may integrate this feature in the future, for now I have other priorities with the team, and just needed a quick script to process data with the spreadsheets the team already had, which included team numbers already manually entered.
The macro enabled spreadsheets are of the .xlsm file type, which has the ability to mess with files on the computer. Because of this, it is possible that some computers, say school laptops, would not allow users to download .xlsm files as a whole, so I included the .xlsx files separately along with code that can be copypasted into it. Even if this is just an excuse, including the .xlsx sheets (which I already had) into the repo was easy and has no negative consequences.
In fact, someone on the team did create a spreadsheet which uses formulas to do the same thing, after we realized that a google sheets script prototype would not be viable in a competition without a reliable internet connection. My issue with it was that their version required the Data Input spreadsheet to be sorted by team number, while I wanted to be able to quickly enter data into the sheet, without having to sort by team number often.
I hope this helped clear some stuff up!