Column Search & Formula

I import excel generated data (in form of a worksheet) from our supplier provided programs into an excel spreadsheet. My excel spreadsheet then performs an analysis using only certain data columns of the imported data.

Background:

1. Currently, my excel spreadsheet has formulas that includes the cell references of the imported data.

2. However, the suppliers' data format may change - what I mean is that another supplier program may have the required data in a different column. I use the same program for all suppliers.

3. What does not change is the heading titles of the imported data worksheet - it is basically consistent among the different supplier programs.

Question:

Is there a way to write a formula so that the formula can go to the imported worksheet and search for a specific heading title of a column, and then place the data from that column in another worksheet?

In other words, let say a specific heading title in the imported worksheet is "Total Benefit" and that it is located in column D and the data needed is in rows D2 - D60 (inclusive).

Let's say - in another worksheet, I need the data in cells D2 - D60 of the imported worksheet in cells A10 - A68.

Currently, I write the formula in A10 and copy it to A11 - A60 knowing that the needed cells of the imported data worksheet are D2 - D60. But another supplier's program may have the "Total Benefit" in column BB (and therefore the required data in cells BB2 - BB60).

Therefore, if my formula in cells A10 is Imported sheet!D2 x 100 - it will be incorrect when I import this other suppliers' data (because it has the required data located in cells BB2 - BB60).

Therefore, if the formula can search by heading title (which is constant amongst the suppliers data), it will make it easier to locate correctly the required cells.
In other words, can the formula perform a search on the Imported sheet! worksheet for the heading "Total Benefit". Once it is found, the formula then takes the data in that column - obviously, it has to match up properly - in that the A10 takes the data from D2, A11 from D3, A12 from D4....

Constraint - Cannot use VBA macros in this solution.