import workbooks or sheets to another workbook

[deanl33069]

I have created 5 workbooks or sheets which have VBA and macros in them.
I have created a new workbook with a userform in it . I would like to copy those other workbooks and sheet into the new one with all formatting and coding.


tyvm