I have been trying for 3 months now and have not been able to get air from the tornado it's impossible..

Tornado appear near the fire pit, check it every time you enter the game.

The tornado will appear on the beach on the left (west) side of the island. It will travel from the bottom (south) to the top (north). It will appear intermittently. Drop a villager that's good at gathering on the tornado. The villager will follow the tornado at a slight distance and it may look like you missed the target, but the tornado will stop and wait while the villager kneels and collects air. Then the village will gather a bowl of air and the tornado will disappear.

Tip: If you train all your researchers as gatherers, you will be able to grab any researcher from the research bench and drop them without having to think about which villager will be a good gatherer.