transpose data through multiple sheets calculate the values based on three datavalidation

any helps?

truly , it's good but I no know if you can fix somethings
first when selection from three data validations it should create the table by code and fill data without create table manually
the second also should create the formula in cell BALANCE by code but shows as value not formula
third when select another item from data validations should copy to the bottom but be carful if I return selecting the item are already existed in the bottom shouldn't repeat copying to the bottom again and if the data validations are empty then should create all the tables and fill the data by code
fourth If I change or add a new data in all sheets except summary then should update in sheet summary
I know this project is complicated but I trust in this forum contains many experts to do that

I really appreciate your assistance and effort

Multiple subroutines created in the attached file. I placed two buttons on the Summary sheet. The "Check Sel Exists" button is used to Check if the selected combination exists in the summary sheet. If it doesn't exists, then a new table is created in the summary page and the data is entered into Fourth tab. The 'populate summary' button populates the summary sheet pulling data from all the other sheets. Furthermore, any change to column E in the other sheets will fully update the summary sheet. The data validtion cells are populated through code with all the values that exist in the data.

Place these subroutines in a module

Please Login or Register  to view this content.

Place this subroutine in each other(not summary sheet) sheet module:

Please Login or Register  to view this content.

great work ! but still something is missed I no know if it's not clear also it supposes bring the item separately what I mean when select the first time the item from three data validation it should bring what I select not bring all and if I select another item it should copy to the bottom without repeat and if the data validations are empty then should brings all
thanks for your cooperation

Here is another iteration. You only need the "Check Sel Exists" button since if three validation fields are blank then the whole summary populates. Try it out and let me know how it fares. I updated the one module below.

Please Login or Register  to view this content.

perfect but not completely it remains one thing if when I select the item from the first time it shows , but when I select a different item should copy to the bottom because a new item I think to mentioned that

if I select another item it should copy to the bottom without repeat

isn't clear my explanation ?

I thought that what you are asking for has been implemented. While one item is being displayed, and a new previously unexisting combination is entered, the summary page is updated with all the item combinations (tables) and the new item appears at the bottom of the summary page. Let me know if this explanation doesn’t align to yours.

yes I would that , but the code it doesn't do it you can check it , I select the item then show and when select a new item it replaces for what I searched earlier item

Do you mean that when you select a new(previuosly unexisting) combination, that the summary sheet is updated with all the items plus the new combination item at the bottom? I understood that is what you want. If you then select the button once more, then only that new combination shows up. I am unable to recreate a condition where a new item is selected and the previous search item shows up. If this answer still doesn't address your concern, please spell out each step with the original spreadsheet items so that I can try to recreate the condition.

all what you did is perfect and what I want
about this

a condition where a new item is selected and the previous search item shows up

yes this condition should be
for more from the first time select item it shows if I select another but is a new then should copy to bottom of previous searched item and so on to rest of new items which searches for them without repeat any item has already searched and existed

then you want that combination item/table to show up individually, right?

what you means combination , may you make clear more please ?
and do not forgot showing each three tables next to each of them

Here's another iteration. Try it out and let me know how it fares. I only had to update this one module.

Please Login or Register  to view this content.

it gives error "object doesn't support this property or method " in this line

HTML Code: 

I updated the code to use the join function instead of the concat method. Otherwise it remains the same. That should resolve the error.

Please Login or Register  to view this content.

thanks
but you still doesn't seem understand me , I put some results when I select more than a new item and how should show in sheet EXPECTED
please see the attached file

Here is an update. Let me know if it works as expected.

thanks
but it repeat copying the items have already existed if I search again for the same items it should just update if update in the others sheets without repeat copying again , may you fix it please ?

So you want to start with say 4 items as in your previous example. You then want to add to any of those four items in the other sheets. Then be able to come back to the summary sheet to see new changes in the 4 items, correct?

You then want to add to any of those four items in the other sheets. Then be able to come back to the summary sheet to see new changes in the 4 items, correct?

yes

So you want to start with say 4 items as in your previous example

but this I'm afraid not sure understand it
to be more clearly , the file in post#20 it's perfect but the problem if I select repeatedly for items has already existed it shouldn't copy again in the bottom just update if they change in others sheets , and if they are new items then should copy and add to the bottom in sheet summary

I've updated two modules. Let me know how it works.

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

amazing !! thanks so much for achieving this project , just I would show message when fill in data validations c2,d2,e2 are doesn't matched for any each sheet then should show message "the items are not available , please Verify that the data is correct " and when show the value is 0 for some item I would change to hyphen "- "
thanks for your cooperation.

Here you go. I added the below code to the formatting section

Please Login or Register  to view this content.

and updated the the code to ask 'The items are not available , please verify that the data is correct. Do you want to create a new item?'

astonishing ! thanks for provide me this a great project
you're the best