Continuous Stock file

[utkarsh4rush]

I have made a file where Sheet 1 represents the first day of the month and so on. Each sheet has the list of products and the opening stock for the day, and the daily production and sales are added, resulting to a closing stock.

Now, i want that every time i make a new sheet, the new opening stock is automatically equal to the closing stock of the previous day and all other counters are automatically zero. Also, suppose a new product is added on say 20th of the month, it is reflected through all the previous sheets (Interlinking all the sheets where changes to one sheet is reflected to others and vice-versa.

Also, ive named my sheets 20180601, 20180602 and so on. So is there a way where every time i make a new sheet, its name changes to the next date automatically? (Not important though)

I want to know if the above is possible. Though i know most of the excels, i have zero knowledge about macros and VBAs. (So please explain it to me in layman language )

I have attached a dummy sheet of what i made

[tim201110]

=iferror(indirect("'"&$f$1&$g$1&row()),)

[utkarsh4rush]

Thanks a lot Mate! Can you please explain me how that happened?