I have a mutli-sheet workbook, each sheet has four standard columns. I
set up a Hyperlink in Column D on my first one so it selecte B1:B25 in
the Current Sheet. I want to copy that to the same cell in each
sheet, however the link remembers the first sheet since that was the
one selected, and I am really looking for Current Sheet.

Is there anyway to do this?