Macro to copy data from multiple workbooks and sheets

I have several workbooks that I need to copy data from row 9 onwards excluding text containing the word "total" in Col A and values to the right of the word total in the the destination workbook from row9 onwards. All the worksheets must be copied to the relevant worksheet in the destination workbook. The row containing the word total and the text bwelow that must be left intact

I have attached a sample source workbook "tax -br1" as well as the destination workbook "consolidated Tax.2012

Your assistance in this regard is most appreciated

See Cross post below

http://windowssecrets.com/forums/sho...874#post877874

You can visit here to have a code to accomplish this task

Split Data into Multiple Workbook « excelpoweruser

Thanks
Rajan verma

Thanks for the reply and the link-will test the code & let you know