create VBA modular for Monthly account payable

hi .i am new in excel and i try to create spreadsheet for monthly account payable. i have lots of problem i will be happy if some one could help me.OK i know i have to study, i did but i did not understand lots of thing.i could create one page for account payable and one page for account receivable and one page for account balance and to link them not to use VBA. and it works.but i like to take one or 100 step and create good one thanks

1- i want the automatically each month one page create and the name of page is the date of (mm,YYYY)Code:

it work for one page, but all other pages when been create in other month has the same table name Table1 and create lots of problem i have to declare variable but i do not how to use it. to make the table the same as page name

** table show the total transaction in each month and has to be update automatically when i change any value in any page. (((i have problem )))
**i use Total pay column and Bank transaction for total payable balance
** i use column pay now and delay to know how much money i give check and is not out from my account