Creating one excel sheet from multiple work books that we have.

[prasanthkantu]

We got thousands of work books in which we have tescases. One test case per one workbook. Now we want to import all of them to a tool which kind of accepts all the test cases in one sheet. so i want to create one target sheet by taking information from all the existing sheets. I am uploading samples her. The Target sheet is the template and the input sheet is the input to the target.