How to add formula using vba in multiple sheets

[Muhammad Hussaan]

I have sheets name 1,2,3,4.. upto 30.In sheet name 1 cell B2 i have daily expense of date 1In the same sheet name 1 cell B3 i have daily income of date 1SimilarlyIn sheet name 2 cell B2 i have daily expense of date 2In the same sheet name 2 cell B3 i have daily income of date 2In the cell C2 i want to sum B2 of sheet name 1 and 2 as month to date totalIn the cell C3 i want to sum B3 of sheet name 1 and 2 as month to date totalIn sheet name 3 cell C3 i want to add B2 of sheet name 1,2 and 3In sheet name 4 cell C3 i want to add B2 of sheet name 1,2,3 and 4 and so on. Kindly help