If dates match, then insert data from pivot table

I have a Summary table in worksheet 1 and a pivot table in worksheet 2.
A shortened version of the summary table looks like this (used / to seperate columns):
Date / Time / TRIMPS
2/05/11 / xx:x / ?
3/05/11 / xx:x / ?
4/05/11 / xx:x / ?
5/05/11 / xx:x / ?

My pivot table has:
Date / Sum of TRIMPS
2-May / 363
3-May / 311
4-May / 243
5-May / 345

In my summary table I want to enter a formula where the TRIMP values from my pivot table will be inserted into the TRIMPS column of my summary chart for each corresponding day (from worksheet 2 to worksheet 1). Example if this date matches that date, then insert the corresponding TRIMP value. Any help is greatly appreciated, and please remember im a beginner with excel so please use as much detail as you can. I hope this makes sense as its difficult to explain.
Thanks in advance

Hi and welcome to the board


To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!