Automatic Update of linked cells using search VBA code

Hi all,

I am looking to automate major parts of the document I have attached as a sample. The DataQuestion is the Input file and the OutputDataquestion is the final result I am looking to get it into automatically.

So the Pivot updates automatically based on the Data sheet

I am looking to update automatically the Tables sheet. The cell B25 and B42 should be updated with =Pivot!$A14 and get the value of Mar-12, as per the Pivot data. I had the following approach in mind:

1) I was hoping to look for the keyword: "Sum of XYZ" in the Pivot sheet, get the range of cells from A5 to A14.
2) In the sheet Tables, check for range of cells B17 to B24 and append them with the corresponding next month Mar-12 if it is present within the range of cells Pivot Sheet -A5 to A14 .

I am new to VBA, and was hoping to get any help. Thank you!