Running a Macro Against a Specific Worksheet

I appolgize if this is already answered by I could not find a solution. I am writing multiple files into one spreadsheet with seperate worksheets for each file. I then want to run a macro from my personal.xlsb file on each worksheet. I've tried several things and can't seem to get it to work.