formula to capture data from pivot table that keeps growing

[Frank J]

I need to capture the "Open Hours" for each month from a pivot table that will grow and expand as the year goes on. There's no way to add the months to come ahead of time as the data isn't there at the source until the actual occurrence. I'm adding an example of the sheet I'm using but expect the formula will work for all months. The data is arranged with the YTD on the left and each month going to the right in descending order from Dec to Jan.

Below it all is the pivot table that pulls in data from another sheet and will grow as the year goes on, moving the previous months to the right as another is added. Currently I haven't been able to create a formula that will allow for the addition of new months
Currently I'm using this below but I need to manually adjust it every month and I'm looking to stop that.

=IFERROR(INDEX(C$49:C$57,MATCH(I4,B$49:B$57,0)),"")

Here's a small example of my worksheet

	2021 YTD							June
		Drop	Win/Loss	Hold %	Open Hours				Drop	Win	Hold	Promos	Open Hours	Drop/Hour	Win/Hour
	Baccarat	$6,790,114	$379,441	5.59%	7,828.36			Baccarat	$1,366,146	$110,716	8.1%	$150,475	1,110.94	$1,230	$100
	Baccarat HL	$27,904,700	$1,859,327	6.66%	22,175.84			Baccarat HL	$5,420,153	$273,733	5.1%	$386,550	2,813.38	$1,927	$97
	Baccarat Total	$34,694,814	$2,238,768	6.45%	30,004.20			Baccarat Total	$6,786,299	$384,449	5.7%	$537,025	3,924.32	$1,729	$98
	Blackjack	$8,733,684	$2,050,360	23.48%	27,236.35			Blackjack	$1,889,660	$505,102	26.7%	$22,675	4,332.06	$436	$117
	Double Deck	$2,002,178	$103,485	5.17%	3,944.67			Double Deck	$544,189	($23,871)	-4.4%	$16,425	575.98	$945	($41)
	Blackjack HL	$687,924	($565,795)	-82.25%	2,351.61			Blackjack HL	$439,462	($40,408)	-9.2%	$3,775	327.30	$1,343	($123)
	Blackjack Total	$11,423,786	$1,588,051	13.90%	33,532.62			Blackjack Total	$2,873,311	$440,823	15.3%	$42,875	5,235.34	$549	$84
	Craps	$9,806,234	$1,934,397	19.73%	6,634.32			Craps	$2,124,619	$364,239	17.1%	$35,600	941.71	$2,256	$387
	Roulette	$3,981,847	$989,951	24.86%	9,909.59			Roulette	$763,447	$229,391	30.0%	$8,050	1,719.43	$444	$133
	Novelty	$2,166,635	$510,040	23.54%	9,731.06			Novelty	$474,494	$34,624	7.3%	$525	1,472.91	$322	$24
	Casino Totals	$62,073,316	$7,261,206	11.70%	89,811.78			Casino Totals	$13,022,170	$1,453,525	11.16%	$624,075	13,293.71	$980	$109
	Budget	$29,715,000​	$4,523,200​	15.22%									Need to use below Pivot table to capture the Open Hours^^^
	2021
	Open Hours
		Jun	May	Apr	Mar	Feb	Jan	Casino Totals
	Baccarat	1,110.94​	1,327.27​	1,255.46​	1,377.28​	1,230.80​	1,526.61​	7,828.36​
	Baccarat HL	2,813.38​	3,991.98​	3,973.71​	4,119.63​	3,616.73​	3,660.40​	22,175.84​
	Blackjack	4,332.06​	5,803.10​	4,940.33​	4,443.22​	3,873.43​	3,844.20​	27,236.35​
	Double Deck	575.98​	739.40​	715.32​	638.53​	609.33​	666.10​	3,944.67​
	Blackjack HL	327.30​	407.84​	376.16​	553.84​	389.27​	297.20​	2,351.61​
	Craps	941.71​	1,288.34​	1,122.45​	1,164.23​	1,057.69​	1,059.90​	6,634.32​
	Roulette	1,719.43​	2,191.23​	1,805.58​	1,454.18​	1,265.09​	1,474.08​	9,909.59​
	Novelty	1,472.91​	2,225.01​	1,698.08​	1,689.14​	1,327.82​	1,318.10​	9,731.06​
	Casino Totals	13,293.71​	17,974.16​	15,887.09​	15,440.06​	13,370.17​	13,846.60​	89,811.78​
		^^^ New months will be added pushing columns to the right

 

[Radoslaw Poprawski]

please provide a link to that file.
since ur working with Pt's its hard to estimate anything.

 

[Frank J]

please provide a link to that file.
since ur working with Pt's its hard to estimate anything.

Do you mean the source file for the open hours? Or this file my example is in?
I can't provide either as it's a protected network and this computer doesn't have the program to upload the mini-worksheets and I don't have admin rights to get it.

 

[Radoslaw Poprawski]

and what about onedrive sharing options or using dropbox?
Also what is important is the layout, same data type in cells but data itself can be a dummy data.

 

[Frank J]

and what about onedrive sharing options or using dropbox?
Also what is important is the layout, same data type in cells but data itself can be a dummy data.

The data is there above and can be copied to another sheet for use, I have no other way to share it.