I need to look up multiple sheets within a workbook to get a single piece of data.
Example:
Sheets- Build/Brett/Leo/Nick
Need to fill Build N:N with cell B from one of the other sheets depending on matching criteria With is column A on all sheets (criteria is 1,2,3,4,5)
Looking so if you move a row from Brett and put it into Leo it will still read the data to Build.