How to get data from each sheet and do addition of item?

[Dave Smith]

Hi,

I am stucked at one point of my work.

I have 2 sheets which is working as database for my work now, both of the sheets has almost similar database like date, brand, product name .
Now I have a sheet called dashboard where i want this data to be shown like the as shown in the image the user will select the year, month, week from the combobox after the selection of this parameter as per the product name (whose values are fixed in cell "C11", "D11","E11","F11","G") the code should find this value through sheet and find specific data if its find more than one particular then it should also add and show this value in Number of items/year, Number of items/month. number of items/week.

For eg: If user selected year 2022 in the 1st combobox , selected January in month combobox & selected week "week-1" in the 3rd combobox and "C11" cell value is "Spanner(M16) & brand name mentioned in cell "C12" then it should find this value in both sheets name "database_1" & "database_2 if both the values (means name of item & brand) gets matched then it should do total of its if in case it is more than in particular sheet or both sheet and this total should be shown in the cell "C13","C14","C15"

pl. have look to my database & dashboard.

I need help for this to create vba code for this i am not getting idea how to write code for this.

Regards,
Dave

 

[Dave Smith]

Hey Experts,
Can Anybody help pl. i really need it plzz.....