I am almost positive this can be done.

I have a worksheet (Master worksheet) with all the data on the residents in
our facility. Every month I have to create a mail merge for some residents.
Thus, I get a list of residents for the particular month and I have to pull
out the relevant data manually from the Master file, which becomes tedious
and time consuming.

Is it possible to create a link between the list I get and the Master
worksheet such that the data will be generated automatically? Even though the
number of entries per list changes, if the column labels are identical, can
Excel find the names of the month in the Master file and copy the respective
data into the monthly list?

If anybody has the answer, I shall be grateful forever.