Copying data between two worksheets

Hi all

I've got two worksheets, A and B, and worksheet B has data on it that I want to copy over to worksheet A. I know it'd just be easier to do a copypaste, but we may set it up so that new tables of data are generated and copied over to worksheet A automatically. So I'm wondering is there a function, macro etc you can use to do this?

I've been checking out the function lists for Excel and can't seem to find anything (running on Excel 2002 by the way.)