Reference a column from a variable

Hi there,

I have a sheet here that has lots of different data in it, I have a column for part numbers, and a few more columns with dates amongst other things, but the last 45 columns form a matrix of jobs1 to 45. Then the rows make up items to be covered and there are approximately 37 rows of this.
In this matrix there is either an "x" or "Done"

Now the titles of Job1 to Job 45 are now a named range and I can now find one of the job numbers, but I can't work out how to access the column.

Basically, the user chooses a job number, and then the macro will pick the item details depending on whether they have been done or not, and copy them to the next sheet to be printed out. But I can't work out how to get a variable that I can use to loop through the column to assess if it is required or not. What is the most efficient way to do this?

The sheet is attached as I realized that this is too difficult for me to explain.

Kind regards
Rob