Excel vba copy data from general sheets and organize them in separate sheets.

Hello,

We have been using this excel is sheet in our business manually, so in the process we commit a lot of errors. It will be great to be able to enter all data into "Sheet 1" and "Sheet 2" for example, and then excel automatically takes this data and organize it in the rest of the sheets as we need it in this case, separated by banks accounts.

I hope someone of you can help me learn what should I do here, what function do I need or maybe what vba code should I use. However, I do not have good knowledges on visual basic.

Regards
Daniel