Chillax,

What is the best way to design a macro that can handle this?

The best way is to not use a macro, and only use the master sheet. And add a column where you enter
the 'subject' for each record. Then you can filter your data set based on that column, showing only
the data asscociated with the 'subject' of interest.

--
HTH,
Bernie
MS Excel MVP


"Chillax" wrote in message
...
Situation: Workbook with four sheets (each sheet represents a different
subject); I have one master sheet that needs to be auto-updated with the
information on those four sheets.