16,17,18 financial years P&L data & format auto display in individual sheet each year

[GVN KUMAR]

sir
i am tax consultant
most time using profit and loss & balance sheet for income tax returns
i am prepare a master sheet in xls file (sheet name master)
its master sheet data entered for 3 year (2016,2017,2018) profit and loss account and balance sheet (it auto updated in 16,17,18 sheets)

any solution for
then auto flow of sheets 16,17,18 same way in master formats (master sheet format)

we are manually prepared a master sheet and 16,17,18 sheet and data entered with array formula of ctr+entered and same data in all sheet and auto hide rows.
then use ok but

but some time master sheet adding some rows but not display in 16,17,18 sheets

so we are again 16,17,18 sheet same place insert adding rows and use ctr+d and same value get it sir in above sheet
its some time taking and some time forgot it of 16,17,18 sheet auto updated after print out and submitted bank. banker find out some data missing sir.
any solution sir

 

[GVN KUMAR]

If you add some additional rows to the data in one main sheet, how to add additional rows in the side sheet as well.