Creating A Named Range

Just thinking that perhaps a Dynamic selection is perhaps a better way. But to be honest until 10 minutes ago I'd never heard of Dynamic Selections so waaaay out of my depth now.

I've found that this formula allows me to select everything that is added to Column E

Formula:

=OFFSET(Sheet1!$E$2,1,0,COUNTA(Sheet1!$E:$E)-2,1)

This is useful as conceivably there could be times when more rows are needed. But how do I amend that formula to skip even rows and then do the same to include columns E,H,K,N,Q????