I have a macro that copies specific cells between workbooks, but I have
several workbooks I'd like to use it with (different company information) and
each is named differently. Because the macro switches back and forth copying
and pasting it names the Specific Workbook to copy from or paste to. Can I
make it generic somehow so I can use the macro with any workbook without
having to rename my workbooks and rename them again when the macro has
finished running.