Indirect Sheet reference with cell reference left function and text

Hello All,

I am trying to solve an Indirect function to reference a sheet that has a space and where the first part of the sheet named is located in a cell reference.

See attached example.

Problem - I need to extract data from sheet "JD54N Due" to insert the time maintenance is due in the trips page. My formula is in sheet "Trips" and references another cell to extract the first half of the sheet name "JD54N" from a cell containing the car and driver reference using LEFT(Find()).

Any suggestion?Indirect with Space.xlsx

SDCH,

That worked perfectly.

Thank you,