I am wanting to create a reference page for several of my sheets

Janelle
Janelle ✭✭✭✭✭

I have 3 different sheets; Projects, Code Request, and Insurance Claims. They all have the same information in the work order column. I would like to create a reference page merging some of the information from all sheets. When a row is added or changed on any of the three sheets, I want the system to look at the reference page and see if that work order number is there. If it is, I want it to update the columns from that sheet. If it isn't, I want the system to create a new row.

Basically, I want to look at this one sheet and know which work order goes with what project, code request, and/or insurance claim.

Answers