How can I pull data from one tab to another if a date is entered into a certain field?

Hello, and welcome to the forum.

First of all the bad stuff - could you read the forum rules and give your thread a title which describes your problem, as per rule 1, please?

OK, on with your problem - what you're asking for isn't impossible, but it would be much easier for us to help you if you could post an example workbook (obviously with any real data replaced with made-up stuff).

You say that candidates will drop off the new sheet as they start work, but will their details still be recorded on the interview sheets? This makes a big difference to how your solution will have to work.

Thank you for your reply. I will change the title of the post and will make sure I read the forum rules, sorry for that.
I have attached a simple version of the sheet. The data will be input into the first tabs (Stress & Thermal - ME)and all information will stay on there no matter if the candidate is successful or not. The starters tab will be locked and I'm looking for the information that is input on the other tabs to be pulled through to the starters if there is a date in the "Start date" column.

The starters tab needs to list the candidates that are due to start with us in the future and once their start date has passed, that entry needs to be removed.

Hope this helps!!!

Thanks again!!

Thanks for the title change.

I've returned your spreadsheet with some formula in to automatically populate the starters sheet. It uses a control sheet to keep track of some numbers, but this sheet can be hidden away. Columns E & F on the starters sheet are also intended to be hidden (or you can move them to other columns, if you don't mind updating the cell references contained in column F).

Does this meet your requirements?

Thats exactly what I need! Thanks so much you have saved me alot of time!!!!

Thanks again