how to link (Data validation) combobox value with Pivot Table to display data and calculat

Please Login or Register  to view this content.

Through Connections I have created Workbook connection to 2 other workbooks (Workbook1.xlsx) and (Workbook3.xlsx) which will be data source.

Please Login or Register  to view this content.

Workbook3.xlsx has multiple tabs for example:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

what I have to now is link the value From second Combobox to dateCompleted (Workbook1.xlsx) to show the following calculations and data only if the first 4 characters (alphanumeric) matches the data in any of the tabs in (Workbook3.xlsx)

Please Login or Register  to view this content.

Data set to look like:

Please Login or Register  to view this content.

Any help is appreciated. I'm new to Excel and trying to figure how to do this.