Opening a consolidation macro from another excel sheet

  • I had this working macro perfectly fine. I wanted to fine tune and hence I wanted to execute the macro from a different file and I did the below. but I get error on execution as out of range.. Didn't know whats wrong in this... can anyone help me in this?