Macros

[Chillax]

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.

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

 

[Bernie Deitrick]

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.