[RESOLVED]Time and name concatenation

[Albatross]

For the record, I checked the search files but came up with nothing that would work. I have a good idea it's on my end but here goes :

I need to do a concatenation of a date format and a text value. the value I'm using for my date in cell c1 is 05/21/06 but when I concatenate, I need it to read back as 2006 0521 TextName.xls

what I have so far is (my cell im working out of is down the sheet a ways) ::
=CONCATENATE("'[TEXT(c$1,'yyyy mm dd')","TextName",".xls]Sheet1'!$u:$ad")

but if this is fed in, it gives me error and the yyyy mmdd is highlighted. The c$1 id the cell where the date (05/21/06) is located and what I need to convert while bringing into the result.

Any thoughts, tricks or suggestions? I'm somewhat stuck and it's probably something simple.

FYI : the Code I was after turned out to be :: =CONCATENATE("'[TEXT(c$1,'yyyy mmdd')","TextName",".xls]Sheet1'!$a:$j")