A Checklist for document received

Hello to all,

I need your help guys please.

I attached 2 excel files here.

1. DSR MAR 2017 AIH
2. DSR MAR 2017 – Checklist

In excel file No.1 have different sheet names. There is a column for Profit Centre, Location, and Date Received. Each profit center have 1 or more locations and I received on different dates.

I just wanted to have a checklist that when I enter the Profit Centre, Location, and Date Received it will be automatically updated in File No. 2 like a check sign or any sign per date.

Or if it’s not possible in updating automatically in file No. 2, I will just insert the checklist in File No.1.

Hope you help me guys in this different format request.

Thank you so much.