Read a Excel CSV single worksheet file and parse the data, filter fields to create sub-sheets, a summary sheet and an invoice

We seek an experienced developer who can receive in an email a single spreadsheet and from this sheet review the macros and formulas and :
- extract from the master sheet - sub-sheets by a specific column that identifies each device (creating individual sheets)
- summarise the number of transactions, value of all transactions and any voided transactions as running totals
- Create a summary sheet of these entries and apply additional fields with charges and taxes and apply sub-totals in Summary sheet
- Create an Invoice showing breakdown

The spreadsheet is currently derived manually into a excel spreadsheet after importing the CSV file

We initially pull the master sheet then derive each device IDs filtered data into separate sheets and create summary and invoice from this

A re-concilliation sheet is also applied from bank deposits

We require someone with the following skills:
- able to parse/query a csv file and pull data in a Db (preferably MongoDb / MERN platform
- able to read the input file as an email attachment to a dedicated email &/or....
- create a web portal where we can import a .csv file and populate data into fileds (example web page available)

Please only apply if this makes sense

I look forward to your proposals/feedback


PLEASE NOTE:
A NDA will be required to engage as data is sensitive, only apply if you are comfortable to sing NDA

I prefer getting an indicative price range than a holding bid

Happy to share file expample anyone who need guidance