I have a sheet that is used as a log. So change order 1, 2, 3 etc. The individual sheets for each change order has data that i want to link in the log. I am trying to figure out how to link the data in a cell in the log such as "description" and have it correspond with the same description on the change order sheet. I can do this where there is only one sheet to link to but when the change order for the log changes from 1 to 2 how does it know to go to change order 2? I hope this makes sense. thanks.
Solved by E. F. in 13 mins