Just out of curiosity, could macros be made to work on already created excel worksheets?

I don't understand the question. You can certainly copied code from one workbook to another. You can add code to an existing workbook.