How to combine similar worksheets into 1 worksheet with continuous update

Hi,

If I have the same structure in 2 different worksheets with the same kind of data how do I combine the data into 1 worksheets but it continuously get updated.

example:
sheet 1

column 1 column 2 column 3 column 4 column 5
1 2 3 4 5
6 7 8 9 3

sheet 2

column 1 column 2 column 3 column 4 column 5
A b c d e
f g i j k

I need to combine both sheets into 1 sheet but it will get updated continuously through out the year.

The simplest way (might not work on all occasions) to pull the exact data from a sheet to another is with a formula =Sheet1!A1 (or similar).