Importing Different Sets of Excel Data From One Sheet

I need to import some Excel data, but the data is not coming in a way that is easy to do so. What I need to do is start at say Column F and import all data from there. I can just delete the previous cells, but is there a way to specify to start at F and go until the sheet is over? Also let's say starting at Column F, Column F is Set 1 data and Column G is Set 2 data. From there it alternates back and forth between the two (H is Set 1 I is Set 2 J is set 1, etc) And I would like to separate these into separate graphs. Is this all possible?