I have a customers name in column A and category of loans like Auto, Housing
& Business Loans in Column D, in Book1.

Is there a macro to be reflecting all the three types of loans separately in
the worksheets Book2, Book3 & Book4 being updated with each new entry Book1?

Hopefully some1 would be helpful enough... ... ... ... ... ...?