Autopopulate other data sheets from a master sheet

Hi,

It took forever to upload this file, please find attached a sample worksheet. The open_all_issue is the master sheet while the others are to be populated. I have entered information manually to the other sheets to show what the results should look like. I am hoping to be able to automatically update these other sheets when the master sheet is updated by running a saved macro.

Thanks

waiting anxiously