Formula to bring YTD values from sheets

Hello:

Please refer to attached file.
I need formula in cell K6,M6,O6 down to get YEAR TO DATE from each of location sheet named in cell K4,M4 and O4 for period ending
shown in cell A2. So values in this case will be from 1/1/2019 thru 3/31/2019.
I have added 2 values manually in cell K7 amd K9.
Let me know if you have any questions.
Thanks.

See attached file, I hope that it's what you need.

I used this formula: =SUM(OFFSET(INDIRECT(K$4&"!r6"),MATCH($A6,INDIRECT(K$4&"!Q6:Q500"),0)-1,0,1,MATCH($A$2,INDIRECT(K$4&"!q4:zz4"),0)-1))

Regards,
Antonio

Hello antaka05:

Works, Thanks

Riz