Hi
if by every fifth row you mean rows 5,10, 15 etc.. and starting in A1 on your " Short sheet" try =IF('Master Sheet'!A$1,INDEX('Master Sheet'!A$1:A$100,ROW()*5,0),"")
Drag right to col L then down as needed

If the cols have headers a slight adjustment will be needed

You can also use INDIRECT, but I do not recommend it, as it is a volatile function

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post