Consolidating data based on a mapping spreadsheet

Hello everyone,

I'm new in this forum and I wondered if anyone can help me with the following Issue. The aim is to have a simple file with three spreadsheets :

-In the first one, I'd like to upload a general ledger with four columns (GL account; Account name; Account Balance for Year N; Account Balance for Year N-1).
-In the Second, there would be a mapping file already set and not supposed to be changed
-In the final spreadsheet, I'd like a consolidated data so that each account in the source file has been placed (sumed up) in the correct section according to the mapping rule.

Basically, the difficulty lies in the mapping rule. Let's assume the GL account is a 10 digits number, I'd like to be able to set a mapping rule by telling for example :

GL Account Section
152xxxxxxx B1 here only the 3 first digits determine the section
40745xxxxx B2 whereas here we need the 5 first digits to determine the section

I've attached a file for the little example I made. The aim is to be able to achieve my goal in three steps:

- Upload the file
- Click on a button to start the consolidation program
- Open the output in a new file.

Thanks very much in advance for your help.

M.

Thank you Arlu1201 !