Tried that

Like this??
=IF(Timesheets!E7="A0014A","W123",IF(Timesheets!E7 ="A0014B","ENG",IF(Timesheets!E7="A0014C","FF37",I F(Timesheets!E7="A0014D","FF46,IF(Timesheets!E7="A 0014E","ROUTE 3",IF(Timesheets!E7="A0014F","PICCADDILLY")

And all I got was

The formula you typed contains an error.

Should I have more ) in??