Random text generator

[bbvierra]

Sheet 1 - A1=New York
A2=Detroit
A6=3/31/2011
A7=1:05 PM

F6= A random choice between A1 and A7 of Sheet 2

A11=New York
A12=Detroit
A16=3/31/2011
A17=1:05 PM

F16= A random choice between A1 and A7 of Sheet 2 , but those A1s and A2s would have to update to A11 and A12. That's my problem that I don't know how to fix.

(This would continue down to A1101)

Sheet 2 - A1=""&A1&" "&A2&" "&TEXT(A6,"m/d")&" - "&TEXT(A7,"h:mm AM/PM")&""
A2="See "&A1&" "&A2&""&TEXT(A6,"dddd")&" - "&TEXT(A7,"h:mm AM/PM")&""
A3="&A1& "&A2&" "&TEXT(A6,"m/d")&" - "&TEXT(A7,"h:mm AM/PM")&" Game"
A4=Go for "&A1&" "&A2&" "&TEXT(A6,"m/d")&" - "&TEXT(A7,"h:mm AM/PM")&""
A5=Go to "&A1&" "&A2&" "&TEXT(A6,"m/d")&" - "&TEXT(A7,"h:mm AM/PM")&""
A6=See "&A1&" "&A2&" "&TEXT(A6,"m/d")&" - "&TEXT(A7,"h:mm AM/PM")&""
A7=Get ready for "&A1&" "&A2&" "&TEXT(A6,"m/d")&" - "&TEXT(A7,"h:mm AM/PM")&""

I might create more cells beyond A7, down to A20 or so.

Does anyone know a good solution to my problem? I'm open to making some changes to my code if I'm going about it the wrong way. I just need those formulas on Sheet 2 to update from A1 to A11, etc.

Let me know if this is confusing.