This video works with multiple worksheets and workbooks. Topic include: 3D-references; hyperlink; named range. Thanks for watching.
Right-click 'Download' and select 'Save Link As' if the file opens in a new tab.