I want to have a main worksheet that i enter data into (sales listed by
vendor), which would then automatically drop the vendor's sales into their
specific worksheet for end of month reconciliation.

would i be able to do this with a macro? HELP?