How to skip columns whilst dragging a formula

I have data fields on every 4th column in a target sheet and wish to interrogate this with formulas from a query sheet in the same XL file whilst eliminating the null data I'd get in the three intervening columns if I just dragged the formulas across. Essentially I want my formula to skip 3 cells in the target sheet when I drag it 1 column across in the query sheet. I've been trying the indirect & offset commands with "column" references as discussed in some threads , but have not been able to make them work for me and realise I am not understanding something in the construction of these formulas that are offsetting or skipping columns. An example I can replicate and understand would be appreciated.

Do the columns in the target sheet have unique headings? If so you could use the MATCH function in conjunction with an OFFSET function. In order for us to provide an example it would be best if we had an example to work with. Can you upload a sample file (with sanitised data)?

Thank you so much, this was a great reply, the picture and the formula helped me figure out what was going on and I've got it working. Once again many thanks.