Wow, worst description ever.

What I would love help on...

I am creating a master sheet that is a quick reference to know if a contractor has been paid or has an outstanding invoice. There are 20 plus contractor worksheets that have more detailed information about what they are doing, invoice numbers, amounts, received dates, paid dates, etc... Ok, easy, that I can handle...

What I envision is the first sheet listing all the contractors in column A then the heading for columns B and C would be "Invoices", with B being "Paid/Up-to-date" and C being "Outstanding".
All I want to do is put an "x" in whichever column is relevant. That would prompt me to go to the Contractor's main sheet for more details. The information would be inputted into the Contractor's detailed worksheet and should manipulate the first worksheet.

So, for example column G on any given Contractor detailed worksheet is simply headed "Paid Y/N". If there are any "N"s in column G, then the x should go in the "Outstanding" cell. If the entire column is "Y" then the x would go into the "Paid/Up-to-date" cell.

It seems simple to me but I have NO idea how to do it...have tried somethings that I thought would work but have to defer to the experts, thanks! Roxane