Scouting using Excel, please help

[Cade123]

Hello,

My team is attempting to use spreadsheets (Microsoft Excel) for scouting this year. We would like to be able to submit data chronologically as we receive it at competition (as in, data from match one followed by data from match two and so on). Obviously, we don't have access to our competition match schedules so we need to be able to input that on the fly. My question is, how do you take data entered and sort it by team if we don't know what teams will end up in each cell?

If other information is required to answer this please let me know.

Thanks.