Collect the values from different Tables and collect them into one Table

Hello friends.
I have a complicated task in front of me that I've been trying to solve for a long time and I can't figure it out.
It's a big challenge and I'm worried if it's even technically possible.
At work, I collect data in excel tables, which are also separate files. In these tables, I enter the work performed, where each work task is assigned a position number. Under this number, I have the price for the work done in another table.
What I need is to select from each table the values with a certain number with a quantity associated with it. Take these values with a given number, for example "1.1.1", from each table and add them to one table where all these numbers are sorted. What I want to achieve is that I will see in one table what the total value of the position will be, for example "1.1.1" from all tables.
I know it's complicated, but if someone could find a way to implement it through formulas, I would be very grateful.
well thank you
Sincerely
Roman

Hello Glen,
Thank you for your reply.
I have exactly the same version of excel that you showed in the picture.

OK Glen thanks, now I understand.
So here are my Excel sheets.

As you can see in the excel sheet called "excel calculation Brunn" there is a list of positions with a price per unit assigned to it.
At the end is a column with the name Total. In this column, I want to generate or extract the total amount of work done, or positions from all sheets like 16-4208.
I have a total of about 35 sheets like "16-4208". Starting with sheet #1 .
Each one of them contains a list of completed work that has a position number assigned to it.
As you can see in sheet 16-4208 there are only some position numbers, because only these works were done in the section under number 16.