Lookup and Cell reference

I have Monthly summery data in one sheet that I would like to find a given month in that sheet, know what the cell location for that found month is and then use offset parameters to locate the cell data into another sheet.

the sheets I am using are Monthly Data and Q1, Q2, Q3, Q4 sheets. I want a formula in the Qtr sheets that will lookup the reference to a cell in Monthly Data and then use the values associated with that month. The format/layout of the data in Monthly data is different than the format/layout of the data in the Qtr sheets.

It sounds simply, find a value, reference that cell and use that reference as an offset to get the actual data. Also, the data in Monthly Data is dynamic and may not always be at the same location - Month could be at A13 one day or A53 the next.

Any Suggestions? I have tried several thing, but haven't seemed to come up with what I need. Is this a formula or VBA code.