Macro to Find specific cell and expand into an array using offset func

[jackcel]

Dear all,

I am looking to create a summary sheet ("summary") which pulls data from respective tabs labeled in Year and Quarter formats ("2014Q3"). Probably easier for me to send the excel over.

Due to the non-standardized nature of the data source and multiple tables within a tab ("2014Q3"), I can't really apply an indirect function to extract data.

I would like to create a macro to:

1. search tabs by referencing the headers in the summary sheet (see below)
2. search the postal districts and parameters listed in the summary sheet (ie postal district 03, < 100 sqm etc - thought of applying an index match for this.)
3. populate the data in the summary sheet.

I have no clue on how to accomplish this besides forming each array manually using an index match function.

Thank you so much!

Jack

Sample Table 1 in 2014Q3 - there are multiple tables of different postal districts and rental for each level and size. I thought of standardizing the top label into say Level 1 25th - so i can apply an indirect function. But how can i automate this through a macro? Each quarter has multiple tables.

[TABLE="width: 851"]
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Postal District[/TD]
[TD]Level 1[/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Level 2 or higher[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]05 [/TD]
[TD]25^th[/TD]
[TD]Median[/TD]
[TD]75^th[/TD]
[TD]25^th[/TD]
[TD]Median[/TD]
[TD]75^th[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]Percentile[/TD]
[TD] [/TD]
[TD]Percentile[/TD]
[TD]Percentile[/TD]
[TD] [/TD]
[TD]Percentile[/TD]
[/TR]
[TR]
[TD]< 100 sqm[/TD]
[TD]*[/TD]
[TD]*[/TD]
[TD]*[/TD]
[TD]*[/TD]
[TD]*[/TD]
[TD]*[/TD]
[/TR]
[TR]
[TD]100 - < 200 sqm[/TD]
[TD]20.69[/TD]
[TD]20.93[/TD]
[TD]21.63[/TD]
[TD]17.12[/TD]
[TD]20.14[/TD]
[TD]20.76[/TD]
[/TR]
[TR]
[TD]200 - < 300 sqm[/TD]
[TD]*[/TD]
[TD]*[/TD]
[TD]*[/TD]
[TD]18.44[/TD]
[TD]19.10[/TD]
[TD]22.18[/TD]
[/TR]
[TR]
[TD]300 - < 1,000 sqm[/TD]
[TD]*[/TD]
[TD]*[/TD]
[TD]*[/TD]
[TD]28.48[/TD]
[TD]28.98[/TD]
[TD]41.44[/TD]
[/TR]
[TR]
[TD]>= 1,000 sqm[/TD]
[TD]*[/TD]
[TD]*[/TD]
[TD]*[/TD]
[TD]*[/TD]
[TD]*[/TD]
[TD]*[/TD]
[/TR]
</tbody>[/TABLE]

Summary Sheet

[TABLE="width: 861"]
<colgroup><col><col span="12"></colgroup><tbody>[TR]
[TD]Postal District[/TD]
[TD]03[/TD]
[TD]These are the parameters i intend to put into the dynamic formula[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Size[/TD]
[TD]< 100 sqm[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Level[/TD]
[TD]Level 1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Type[/TD]
[TD]25th[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]2012Q1[/TD]
[TD]2012Q2[/TD]
[TD]2012Q3[/TD]
[TD]2012Q4[/TD]
[TD]2013Q1[/TD]
[TD]2013Q2[/TD]
[TD]2013Q3[/TD]
[TD]2013Q4[/TD]
[TD]2014Q1[/TD]
[TD]2014Q2[/TD]
[TD]2014Q3[/TD]
[TD]2014Q4[/TD]
[/TR]
[TR]
[TD]Rent (PSM)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]