Advanced Index Match VBA

[SWETHAKHATRI88]

Hi. I have an excel workbook with 2 key sheets Control and Combine. Based on a column in sheet combined, multiple new worksheets are created based on a macro(Not consistent number of new sheets). There is also a string called Balance in every worksheet except control and combined
I would like to search the Balance word in every worksheet except control and combined, copy the adjacent cell value, find the corresponding sheet name in control (which is also there in Q2 of every sheet, match the dates (q3 in every sheet) and populate the adjacent cell value for all worksheets
Attached is my sheet for reference. Can this be done through vba. Thanks in advance.
I am aware Index match can solve but am able to do only for one sheet

Control sheet looks like below

	04/10/2023​	04/10/2023​	05/10/2023​	05/10/2023​
	OB	BALANCE	OB	BALANCE
test1
test2

Worksheet looks like below

		Column Q	Column R
		test1
		04/10/2023​
		OB	100​
		BALANCE	50​