Formula or vba help needed

[SWETHAKHATRI88]

I have 2 sheets called CON, COM
based on the values in column q in COM for each unique value a sheet is created in the same workbook. In the new sheets I have in R2 opening Bal. the value of opening bal needs to be taken from sheet CON. There is a date to be considered as well. Along with the sheet name.
So in sheet CON the data is
REDB. 04-10-2023. Openingbal 50
BLUEB. 04-10-2023 openingbal 100

Worksheet REDB has the data as
opening Bal ?????
04-10-2023

Is there any way I can dynamically pull the data out in sheet REDB from the sheet CON. I am expecting 50 to be auto populated. Next day whatever is the value for 05-10-2023 in CON to be auto populated

Thanks in advance

 

[SanjayGMusafir]

Need to see how exactly Worksheet REDB looks like... I have understood what you have explained but what happens on worksheet REDB when date changes shall be important.

Share some real data in a useful way to understand same...

Then only can I think of any possible solution...