I'm not sure if this is possible, it is similar to a DGET but not working.
Example
Sheet 1 - Columns - Area, Address, Date
multiple rows of data, each row represents one client record

Sheet 2
I want all the rows that match an Area number, i.e.
Display
Address and Date for rows that match area 4

Sheet 2 has several different formatted blocks and each block represents an
Area, and want to populate those blocks with the addresses & dates that meet
the Area criteria

i.e. Columns B-E list Area 4 addresses/dates
Columns G-J, list Area 2 addresses/dates
etc...

Don't know if this can be done in excel, trying to avoid having to create an
access database. Because it's like building a report based on the data and
criteria, but that's what trying to do, is build a report listing the data.
Pivot table couldnt' get it to work for me.

Any ideas.
Thanks
Nadine