Hello, I use excel 97 version. I have a workbook with a few worksheets in it. I don't know if I need formulas or some type of method to achieve what I want. Please tell me the steps need to do the following
Worksheet 1 - this is what I have no
A B C D
1 3 (formula this cell) (formula this cell) (formula this cell
2 5 (formula this cell) (formula this cell
3 8 (formula this cell


When I enter a new number in cell A4, I want that same new number to automatically be inserted in cell A4 of worksheet 2, worksheet 3, etc
Then, I need in worksheet 1 the formula in cell B3 to be filled down to cell B4. Also cell C2 formula filled down to C3. And last, cell D1 filled down to D2
Now, when that is done, I want the same cells in worksheets 2, 3, etc. be filled down automatically

What I have tried: I can "fill down" manually but have too many to think about doing it that way. I have tried a macro to fill down the formulas in each worksheet but the macro always starts back to the original cell the macro started from which does not allow for additional rows to be added for ongoing data in the future, does not work
I would really appreciate any suggestions anyone has :-
Bar