Copy cells from one sheet to another

Originally Posted by StephenR

To remove doubt can you update your attachment because it doesn't seem to tally with your latest statement about one sheet for each customer.

Have you considered pivot tables?

Updated.

Yes I've tried with pivot, but not a big fan of using pivots as it narrows down the customization ability. For example columns colors etc...

This file will be sent to users that need to view their customer and take action based on aging time.