subtoal update automatically
 

Hi to all
I am useing subtotal from data menu for my passbook.
What i do is when i want subtotal i copy data into new worksheet and use
subtoal from data menu. every time.
Is there any way that i can be updated automatically when i type data in
datasheet and it update in copy sheet where i used subtotal.

Is any help.

thanks

Tiya