Thanks for that. It shows me that it's NOT the formatting you are interested in.
Are you expecting your users to read the questions on Sheet2 and answer on Sheet1? Surely not, but if so, I would strongly recomend a cleaner UI and the coding could then be very much easier.