I have a master database I use to submit check requests, deposits, etc. Each
account type has it's own number and name. When I submit info. into the
master database, I would like the account info to automatically appear on
it's relevant worksheet with has the same columns. Example:

Master Database sheet:

Account Name Account# Amount
Library Revenue 3343 $25.00
Lost Books 2635 $20.00

How do I get the Library Revenue Info to automatically appear on the Library
Revenue worksheet?

I hope this is clear. Thank you for your time.