Can't get vlookup nor advance filter to give the desired solution.
 

(excel 2003) I have a data list to search and copy from - it's approx 150
rows x 12 clmns. I need to copy the data (entire row is fine, but only need
8 out of 12 clmns) based on the "Location" . Within "Location" I have 8
different solutions {ex "R1" for room 1, "R2" room 2, and so on} I only
need to copy rows that have a "Location".

I need to keep a link back to this master workbook, and would like to have
this new workbook I'm creating to either auto update or update by a simple
macro.

Once I have the data copied to the new sheet, I'll sort by a different field
that is copied over {completion date}. Am I even looking at the right
functions ???