Thanks AliGW for your reply, you have a way to learn it. But i am not good in excel. could you or any one else can give me a VBA. thanks.
Actually it is not an amount or numbers to combined..
I want all text or numbers same format from all sheets to be copied and paste in sheet "ALL"
Thanks
Bookmarks