I'm not sure if this can be done, but I am sure that you experts will tell me if it can't.
I handle the financial affairs for a number of clients and keep my own records of their current bank balances on separate Excel Sheets within the same file.
On Sheet One, I have a list of all the clients' names and I have to enter an amount of money against each client. Sheet No. 2 and onwards will represent a Bank Statement for each of the clients.
Am I able to enter a figure on Sheet 1 against a particular client's name and have it automatically inputted onto their 'statement' sheet below the last entry that was made?
The problem I'm coming up against is in making any subsequent entries appear on the statement in the line below. (i.e. getting the script to go to the client's personal page find the last entry and drop down a line)
Too complicated?

Please bear in mind also that I am not an expert in VB.

Many thanks.