Hi! I have this code which takes data from one sheet and when running a macro it displays a dropdown.

With Sheets("Indata").Range("Q6").Validation
    .Delete
    .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:=xlBetween, _
        Formula1:="=IPE!$J$307:$J$324"
    .IgnoreBlank = True
    .InCellDropdown = True
End With
How can I in Formula1 add values from 2 more sheets named HEA and HEB. They are within the same range as "IPE!$J$307:$J$324". How can I also write the code that within range J307:J324 it skips the blank cells in that column

Thankful for any kind of help.