I have been asked to import multiple excel docs into one central excel docs
to so show all the columns in all excel files (IN ONE DOC)

How would i do this and for it to be automated ideally?

PS im not a vb programmer

Thanks,
steve