Macro: Copy then sum

[kds001]

I want to create a workbook for bank reconciliations. The first worksheet is a summary sheet, then I would have a worksheet for each year I am reviewing for bank accounts, and a worksheet for each for credit cards. I want to have a macro that prompts to ask how many accounts for each worksheet. Then it would insert a schedule for each account based on the response to the prompt. The schedule copied would be 4 columns and 16 rows. I then want to have a total on the summary page for each worksheet.

So far I have figured out how to get the prompt to work but I am struggling with copying and inserting the schedule. Once I get that I will probably also need helping with finding a way to get a total on the summary.

Any help would be greatly appreciated!