This code will copy the range in Headers & Banners to wherever your active cell is and whatever worksheet it is on:
Worksheets("Headers & Banners").Range("B3:P10").Copy _
This is all one line - the underscore with a space before it is a line continuation character.
Note that in Visual Basic it is normally not necessary to Select a cell or other object before acting on it. The macro recorder records these 'selections', but they are not required.
As the only 'fixed' worksheet is Banners & Headings you probably want to store the code with that sheet. Right-click the tab name "Banners & Headings" and select 'View Code'
Paste the code into the Visual Basic window.
You could then attach the macro to a button on a toolbar to make it easily accessible:
Right-click a toolbar and select 'Customize'
From the 'Commands' tab select 'Macros' in the left pane, and then drag the Custom button icon in the right pane to the toolbar.
Right click the new icon, select 'Text only in Menus' and then select 'Assign Macro' and select your macro from the list. Click OK and then close.
Now wherever you are, clicking the button will run the macro and copy and paste that range of cells, starting at the selected (active) cell.