I currently use VLookup on a few worksheets to get data from another
worksheet. I don't use the same formula for each worksheet though because
they represent a different company and thus a different column from the other
sheet (the one I'm getting data from). Is there anyway to instead of using a
number for the column VLookup is searching in to use a name?

I ask this because the column numbers will more than likely change (and I
have no control over this). However, the names remain the same.