Collecting and balancing all pages of the file on one page without duplication

[Hany ali]

Peace be upon you, dear professors... Please,help me find a solution to my problem. I want you to compile all the months of the year into a summary page, knowing that each page of the file includes an entire month, and the remaining months of the year will be added in the future, without repeating the name of the existing resource. In column B combined with the name of the trip in column C, to be mentioned once, but in total amounts... I will put an actual example of the required result on the Summary page. Thank you very much, and may God bless your efforts.

 

[p45cal]

In the attached, a summary table at cell O2 of the Summary sheet.
It needs updating by right-clicking it and choosing Refresh.
It's a Power Query solution that will incude new month sheets if:
Those new sheets contain a proper Excel table which:

• Have the same headers as the other existing sheets
• The table's name begons with Table
• The table does NOT include the Totals row

(see the existing tables I've put in as a guide)
Make sure that the name of any tables you don't want to include in the summary do not start with Table.

 

[Hany ali]

Excellent , if it could be with equations,because as You Know i Want to change Direct when i add new Data and really I Don't Know any thing About Power Query solution ..Thanks alot

 

[p45cal]

if it could be with equations,because as You Know i Want to change Direct when i add new Data and really I Don't Know any thing About Power Query solution

Those equations would be very long and difficult to maintain. That's why I gave instructions on what to do with new data. There will be nothing to change in Power Query; all you'll have to do is refresh the table by right-clicking it and choosing Refresh.

 

[Hany ali]

I am very sorry, but I have repeatedly tried to do such a job myself because the file I own is larger than what I uploaded, but I failed. I wish there was an easier way to solve the problem, because I had never worked on this type of solution before

 

[Hany ali]

Please with your permission, can this be done with equations or VBA Code

 

[Hany ali]

Hello Up Please

 

[vletm]

Hany ali
Press [ Do It ] -button.
Note #1: There have to be always something in both Supplier name and Trip Name.
Note #2: I skipped to do cross-checking.

 

[Hany ali]

Excellent.. you are creative, this is really what is required, thank you very much