There are more complicated ways of doing it which are more dynamic, for instance you could create a separate sheet for data collection and use a vlookup formula on each column to find and return each value.

See updated attached