Excel copying text

Hi,

Hopefully someone might be able to help. Can you tell me if I can copy text in one worksheet to another continuously? All the text is in the same row and column, but the length of text varies depending on the comments. I know that ='Sheet2'!A2 will copy the text from worksheet2 to another, but I need to do this continuously through out the worksheets. But cant seem to figure the function -

thanks