Two spreadsheets, multiple data, need to pull specifics from one to the other

Test workbook.xlsx


Hi all, I am new here and I apologize now if I confuse you. I know this should be simple to accomplish but I can't seem to figure it out??

I have to run two seperate reports out of our system to get all the data I need. Than I must manually go in and add in the missing data from one to the other, while comparing the two worksheets to ensure both show all the same projects.

I have attached an example and wondering if you could help me figure out how to get the Budget to Actuals worksheet to populate the "date created" in column B from the second worksheet named project date. In one worksheet the project code and description is together in one cell and in the other worksheet it is broken out into two cells. Is there a way to get excel to match up say A5 in Budget to Actuals with A2 in Project Date and then pull the Date per that row into the Budget to Actuals spreadsheet appropriate cell?

The actual spreadsheet has about 10,0000 projects, also it is a weekly report as billings and expenses incur weekly, so this is something I do on a weekly basis and would like to automate it.

Test workbook results.xlsxThank you for the response, however it did not work, it changed the date that was already there on the project date sheet but did not add the date into the other sheet?

I uploaded a ss with the results of using the code above.
I need the dates in that column on that sheet to autopopulate into the column named date created per corresponding project code in the budget to Actuals sheet. Does this make more sense? Sorry I am so frustrated with excel right now.

This is a code, not a formula. There is a button on sheet project.