populating worksheet from a main sheet

Hi excel gurus,
I am looking to create a spreadsheet that enables me to manually enter conversations with staff from performance reviews.
Currently I manually type the information into each cell. with each new conversations being entered on the line below the previous.
What I was wondering was possible, was to have a main entry worksheet (similar to a database entry sheet) where the data can be entered into this one page and then automatically be input to another worksheet in an offset fashion.
The idea would be that each new entry on the main entry worksheet, would automatically be inserted on the line below the previous entry.
Thanks for your help

Originally Posted by RobertMika

Robert This can be done using array INDIRECT formula.
Attached your workbook.

Hi robert,
Thanks for the reply.
The file is attached

Originally Posted by RobertMika

I do not see any entries.
Is there going be one entry or more?
Do they stay on this page or they will "vanish" after being copied to another sheet?

Hi Robert,
There would be more than one entry. so each new entry would need to then update under the previous entry.
The entry does not need to vanish, but i would want to have an empty input sheet to start with for each new staff talk.
This could just be a manual clearing of the old entry.
The important thing is the entries always being available on entries sheet for later reference.

It is easy the way it currently is, to type everything into the entries worksheet, but if it is possible, having a nicer looking worksheet as an input sheet just makes it look a lot nicer.

Thank you for your help.

Originally Posted by AndyLitch

Attachment 294380

The above is a userform style approach... If you prefer

Hi Andy,
Thank you for having a look at this.
That works well.
I will need to read up on how to use userforms for other sheets as well.

Originally Posted by AndyLitch

Hi Rob

If you use Excel a lot then it's worth getting to know userforms especially for database style applications.. You can customise them and they're a lot faster.
If you need any help let me know

Thanks,
Have been looking at some online videos of how to set them up.
looks easy enough. and i can see some great use for them.

Originally Posted by AndyLitch

Attachment 294511

A tarted up version of same file..To demo how easy it is to make it look more professional

looks goood.
can a drop down box be added to the CSS section to show different people?

spent the afternoon looking at online videos for this stuff. looks like more time learning this stuff tomorrow.
Thanks for you help

Originally Posted by AndyLitch

Presumably when you say a drop down of the CSS you'd want to select a manager/sup and have all the people under them listed

That's correct. I could then select the person conducting the review of the staff member.

Try this...

HTML Code: