Macro not changing link for opening balance as I run macro in different sheets

[st_judeu@yahoo.com]

Good day all.
Please I'm new to macro and I have this challenge. I have a file for my daily transactions. Each day's transaction are recorded in a new sheet named Jan 1, Jan 2, etc. Each sheet has the following cols.
Col A S/N
Col B Items
Col C Opening Bal
Col D Quantity Bought
Col E Total Available
Col F Total Sold
Col G Closing Bal.
I recorded macro for all the items in the columns in Jan 1 except opening balance because there is none. In Jan 2, I recorded a macro for opening balance which is closing balance in Jan 1. But my problem is that when I ran the macros in Jan 3, the opening balance shown is that of Jan 1 closing balance. What adjustments will I make to enable the macro reflect the appropriate opening balances? How I wish my explanation is clear enough.

[protonLeah]

Attach a sample workbook.

To Attach a File:
1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit

[st_judeu@yahoo.com]

Please file is hereby attached.

I'm sorry about my late response. I was in a local community where I did not have access to the internet.

Thanks for helping out.