I am attempting to build a new worksheet by automatically extracting data
from within another worksheet. I want all columns to be included in the new
worksheet but I only want the rows that contain a particular name [variable]
from one of the columns. And I would like the new worsheet to update
automatically each time new data is entered into the first worksheet, i.e. an
MS Access Query where I build the Query based on the name column.