The Personal Macro Workbook is in your user profile and lets you use your macros between your files.
You can scope your macro to the Current Workbook, a New Workbook, or in your Personal Macro Workbook. Click this, and a dialog pops up allowing you to name your macro and set a keyboard shortcut. You're looking for the third option in the Ribbon, Record Macro.