Analyze some Data

Objective : Create simplified spreadsheet from multiple different spreadsheets Details 1. Need to be able to process spreadsheet to identify 'key field' to match the entries on one spreadsheet with others Note : This step might need manual effort if clean product key is not present in the files 2. Pull /summarize information from different spreadsheet using the key 3. Merge the summary data from different spreadsheets into a single spreadsheet in a pre-defined format using the key field [ This is the desired outcome] 4. Need to process about 5-10 sheets of data - each with <1000 rows Important: Will need to sign non-disclosure agreement for data