not A3, just an example, but whatever cells u want it to show

but then I still need to update each time since it's not auto update

no ar it is always linking to those cells ma.. no matter whether the row highlighted or not

but new overdue won't be auto shown on report sheet, and if overdue is completed and gone from master sheet, the report sheet will run into error

what are new overdue?

perhaps u should tell us an example of what you are trying to do.  and what u want to print and show to your boss

the new files will keep update on master sheet, and if these new files overdue one day, then these files data won't be auto update on the report sheet

"files" are like file names, dates, etc. on the master sheet?

yes, it's....seem like email you would be better idea.....

it's emailed to you