You want to bring lots of bits of data together from different sheets and tables.


Solution

You can use the VLOOKUP function in Excel to bring your data together in one sheet.


Steps

Watch this video from Pip on how to use the VLOOKUP function