Create a spreadsheet which can combine 2 sets of data and then manipulate/filter it and then create a csv output

Requirement: Create a spreadsheet where we can combine 2 separate spreadsheets together, manipulate the data and then create a function to export to a csv file in a certain format. This piece of work brings data together from 2 sources which we will download ourselves on a daily basis: Sheet 1 (AH Data) Sheet 2 (PF Data) Stage 1: Importing all data and merging 2 sheets Create a sheet which has 2 buttons which will allow us to import the 2 above spreadsheets from local files on a PC. Sheet 1 has data on several tabs (could be 50 or more) this all needs to be consolidated on to one sheet. A VLOOKUP will be required to add 4 columns of data from Sheet 2 onto the relevant record in sheet 1. This will give us a full data set for the day. Stage 2: Data Manipulation Once we have all the data on one sheet it needs to be manipulated. We need to create certain rules which will rule out some of the lines of data. There will be 2 main rules that need to be applied. We believe these will be IF functions. We then need to remove duplicates. This process will then give us the data set we require. Stage 3: CSV export We would then like a button which would export certain columns of this manipulated/filtered data into a CSV file. Other Information: This sheet is to be used on a daily basis. It will be the same data sources but different data each day but the same filters would be applied. The actual detail of the work required and example sheets 1 & 2 will be given once the bid is awarded.