Auto-poulate data across worksheets thru Lookup or Match or Index or Offset functions

Hi,

I don't know whether this requirement has already been resolved, i am posting without really having searched thoroughly in this forum.

I need to auto-populate data (in the yellow-colored cells as in the output screenshot) pertaining to certain months from a Source sheet (refer source screenshot) when month is changed in a cell inorder to populate certain graphs.

I've also attached a sample workbook with dummy data. Can someone help??


Sarang