I am not sure that will help me unless I am not understanding it correctly.
The picks are all submitted to me in multiple different formats. So it is me entering in the data on each sheet, unless it is submitted in excel.
In your example what formula would I use to compare their pick to winning team? I am looking for something that will auto fill all sheets once master sheet is filled out.