1. Take multiple excel data sources
2. Create interface to upload these sources into a user maintained microsoft access database
2.5 Linkages between data sources would be user maintained (eg. new tables in access)
3. Then create a new excel front sheet which 'talks' to this database live and able to perform calculations and analysis of data from this access database (eg. dynamic dashboard customisable by user lan id or access levels)
6 freelancers are bidding on average $193 for this job
More than 15 years of experience with Excel and VBA-Programming. I will provide 100% working code for you. Daily work as Technician in the steel-branche.