VBA and Macro Coding Required for Excel 2010

Hello,I have two excel workbooks: 1.Daily Energy Report(DER) and 2.Energy Balance Sheet(EBS)
I enter daily data in DER but at the end of every month,I have to prepare EBS.Also,sometimes I have to prepare the EBS of any month in a short time,which is quite tough :(

The first sheet of the EBS is to be manually imported from the respective month in the DER and thereafter all other sheets in the EBS are linked according to appropriate formulae to this first sheet in EBS.So if enter 1 date of a month in EBS sheet 'MWH' as highlighted,then this command should search that date in DER and,if found,should copy the respective column data from DER to respective column data into EBS.

Is that possible in excel?