Cell value = " bat" then copy whole row to another sheet named cat_bat

[Krantikari]

Hi , I am working on automation and need few tips.
1- my workbook have 5 sheets having data which is not constant in terms of rows.
2- for my tab category in column A named type , I have types bat A,Bat B and Bat C. i need to copy data of bat A to sheet named category_bat A, data of bat B to category_bat B and similarly for C.
3- also i want to copy data from multiple workbooks to a sheet one below the another and add and additional column in starting having type . For example if i copy data from bat_A.xls, followed by Bat_b.xls then the data copied should have a row in starting showing there category.
4-i have created a template tab where in I have data from column A to G already and copy data from another sheet from column H till AA1. Also the column I having country should be either US or Canada.
Please help me with the approach sorry i can't share the data and file as its confidential.

 

[Zot]

It is hard to image from your explanation. If you cannot provide the actual data, you can creat a mock-up data and use XL2BB so that helpers out there can copy your simulated data for testing so that the solution provided works.