Fill planner table relying on data from another table winery planner

Hi, I have a table which basically shows the tanks we have in our winery, I have another sheet that I can input Batch name, date harvested, days needed in Tank 1(T1) and days needed in Tank 2(T2) ie. so I can harvest into one tank and then rack or press into another tank. Also data about how many days in T1 and how many in T2.

I would like to automatically fill the planner table with the batch and tonnes into the appropriate cells when the tank is being used.

i tried vlookup but it comes unstuck whenthe tank gets used twice. It finds the first instance in the input table and fills the cells appropriately for Tank 1 but if I try and use the tank again it wont find it. Also havent got around to filling Tank2 data.

I am guessing I will need a macro for this If anyone can help and if they are in New Zealand I will get them a bottle of good wine for their troubles, sorry for anyone outside of NZ as it gets a bit tricky sending wine over seas.

Thanks in advance especially those that cant take me up on a free bottle of wine

Cheers

I have attached my first attempt so you can see what I am trying to achieve

I have made a bit of a cockup in the data entry sheet, there should only be 2 "Days" collumn's the first "Days" relates to the days in Tank 1(T1) the second is not needed and the third "Days" collumn relates to days needed for Tank 2(T2) I will fix collumn names to Days T1 and Days T2