Insert-Names

I have multiple workbooks which have all of the same range names in each of them. I have set up a macro in one of the workbooks and I would like to copy the Range names and the macro to the other worksheets.
Is this possible? Would appreciate any help!!
Scott