hi mike,i am mallesh,please help me in this "Implementation of automated reporting tool for various excel sheets and capturing data into single data sheet using Macro." the macro may be implemented with help of VBA(visual basic for applications)