Automatic data entry on other sheet based on criteria

Hi,

I am working on excel which has 3 pages, 1) Sales 2) ABC 3) XYZ. what i am trying to do is when i enter information in Sales account it should also copied onto the other sheet Either ABC or XYZ based on the information given for A/C details in Sales Sheet.

I have attached the file for reference.

Appreciate if you can help on the same.

regards,
Mehul

Perhaps something like this? using array formula

Thank you Azumi for the support. yes this is what I was looking for. It will help me reduce double data entry.

Regards,
Mehul