you need to create one macro to consolidate all test cases at one sheet. then make sure that Excel -addins are available...then highlite all test cases which are in consolidated Excel sheet and go to...