I have created a large, unweildly spreadsheet that gets daily/hourly updates. It is a production schedule that has a worksheet for each production line we schedule. The products tend to jump around (i.e. they don't go from 1st worksheet to the 2nd worksheet: A-> B -> C...It could go A->C->B, etc). I currently maintain each production line manually ensure the start/end dates are accurate and then manually move the 'end date' to the next step on another work sheet.
My Index/Match function works (Screening, B4) as long as I manually type the name of the worksheet into the formula. I find this time consuming and would like to have the formula on the Screening worksheet in column "B" and then tell it what worksheet to pull from in column A.
In the attached file, I'm pulling production end dates (column B) from 'WP - C84' or 'WP - CA131' into the 'Screening' worksheet (Avail to Screen, Column B) by matching the Sales Order WINS number (Column C on WP - C84 and - CA131; Column D on Screening).
This type of formula will be used to link all 27 production lines (as needed), the screening schedule, and ultimately update a backlog sheet, so I made a much smaller file to submit for review.
I appreciate any and all help - I'm thinking it may be a "'" or () situation, but after staring at this for the last 5 days, I give up and am asking for expert guidance. Thanks for any consideration and/or input!