Can we dynamically pull values from formula row depending on dynamic quarter and year?

We want to pull values in current quarter and previous quarter dynamically from the formula row. Is there a way to do it using IF formula or any other way? In the below screenshot, need to pull yellow highlighted cell values dynamically from the green cells depending on dynamic Period and Year in the yellow highlighted columns.