I am new to the forum and have been looking at prior postings and do not see anything posted for my current situation.

EMPLOYEE DATA SAMPLE.xls I am creating an employee data sheet for new hires (members of multiple unions) to have all information readily available to them and for us to easily enter the necessary data to an Oracle database. However, to get the proper information, the data will based on the outcomes of two data validation drop down lists 'EMPLOYEE DATA!' cells A13 and D13. There are multiple sheets to the Excel file and similar information on each sheet, with different data for union contributions and deductions. I would like for the data based on these two criteria to be pulled from the other sheets onto this one 'summary' sheet. Information is based on the union number and the 'job name'. Some unions have five or six deductions/contributions and others have 11-13...just depends.

Based on the current selections in A13 and D13 on 'EMPLOYEE DATA!', I would like for the data from the corresponding sheet to appear on lines A19 (contribution and benefit names that appear in sheets in the A column and the $ currency numbers based on the data from the columns matching the data selected in D13 to be compiled under B19.

Any help would be greatly appreciated and if more information is needed to figure this out, please ask. I am attaching a sample, dummy data for you to review and see what information is needed and from where the data is coming from.

Thanks,
Jennifer