Match value(s) in column with headers of another sheet and paste a cell value from column

Hello again!!

I have an ongoing worksheet that I have been fumbling through...

I am not the best at VBA, so don't laugh too bad at my efforts.

This issue has stumped me, tried googling and searching, but to no luck; Only finding information on column vs column compare and copy whole columns, etc...

This is my problem:

I have a workbook that has had a ton of manipulations to get me to this point...
I have it to where it subtotals my 'planned qty' by each day on the "SubTotals" tab...
Done with my macro named "ConsolidateData()". (I figure that I would just call a new macro after this one to add the missing info.)

I have a "Log" tab (which gets its data elsewhere).. The "Log" tab has the days of the year as the headers, and under each day for whatever product was produced there are values (and blank spots if no production). The number of Products changes as time goes by because we add more (new) products to our production line.

What I am trying to do is this....
I am trying to get a macro that will look at the date in the first column (column A) of the "SubTotals" tab, search in the "Log" tab, find that column and then paste the 'total' (sum) of that column (in which the value is already there, but the line number could be different if more products are added later) into the "SubTotals" Tab in the third column (column C) for the appropriate matching date...

is that possible??

I have tried to do some crazy transpose copy/paste things just to get sizing errors and more flustered.

I am at a loss, and am calling for assistance from the Jedi Masters of this forum...

I hope that my explanation is clear enough and I didn't just make it more confusing!!

Thank you...

PLAN-test4.xlsm

I tried it out.. and it works perfectly... Thank you...!!!

as always AB33, you have come to my rescue with some awesome work!!

I noticed the modules 11 and 12, are they part of the magic?? I, as always, look at what was done and try to learn for the future... I still have a long way to go!! but it is fun trying to make things work, especially if there is someone to occasionally lend a helping hand...

Zoediak,
I was working on other threads and mixed up the codes. They are not complete codes, but if you could pick-few lines, so be it.

Got it... thanks...

I did look at it and notice they were calling different sheet names, so I figured that you were probably working on other projects..

and thanks again!! + rep your way!!