Here's an idea which might appeal to you,
thoughts enclosed in this sample:
http://www.freefilehosting.net/download/3hj8k
Property Maintenance.xls

Assume identically structured source sheets: Gables, Gold Leaf, Lawson Sq,
etc
with key col = col M (MID), data from row 2 down
*MID = Move-In Dates

In a new sheet: M,
Create a DV list in A1 to select the property, eg: Gables

In B2:
=IF(OFFSET(INDIRECT("'"&$A$1&"'!F1"),ROWS($1:1),)= "","",OFFSET(INDIRECT("'"&$A$1&"'!F1"),ROWS($1:1), )+ROW()/10^10)
Leave B1 blank. This is the criteria col

In C2:
=IF(ROWS($1:1)COUNT($B:$B),"",INDEX(OFFSET(INDIRE CT("'"&$A$1&"'!A:A"),,COLUMNS($A:A)+4),MATCH(SMALL ($B:$B,ROWS($1:1)),$B:$B,0)))

In D2:
=IF(ROWS($1:1)COUNT($B:$B),"",INDEX(OFFSET(INDIRE CT("'"&$A$1&"'!A:A"),,COLUMNS($A:A)-1),MATCH(SMALL($B:$B,ROWS($1:1)),$B:$B,0)))

In E2:
=IF(ROWS($1:1)COUNT($B:$B),"",INDEX(OFFSET(INDIRE CT("'"&$A$1&"'!A:A"),,COLUMNS($A:A)+7),MATCH(SMALL ($B:$B,ROWS($1:1)),$B:$B,0)))
Copy E2 to J2. Select B2:J2, copy down to cover the max expected extent of
data in the source sheets. Cols C to J will return only the lines with
specified MIDs from the source sheet selected in A1, with lines neatly
bunched at the top & sorted in chronologic order by MID dates.

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---