VBA to copy data from closed workbook to open workbook

Hi

I am new to VBA , can it possible that wat i did manually can be automate below are the step which
i daily do to complete the report for referenve i attch the three files

Step 1- First i open the file "data.xls" and insert the status coulumn status , in this coulumn i used
the VLOOKUp TO get the staus value for each clientid fromthe file Mapping

STEP-2 - After ist step i insert TWO column ( Month , WEEK ) column afte the coulumn Date/Time Stamp
and get the month & Week (like "WEEK1")

STEP3 - After above steps open the file report and copy the data from " data.xls" and paste them in report.xls

Wat i want is that possible without opening the file data.xls the step1 & step2 is perform through automation and copy the data
in my open workbook report.xls