Macro help to copy data from one workseet to another

[AdRock]

I am trying to create a macro which will help eliminate a laborious task of copy data from one sheet to another.

Here is an example of some data I need to copy

Class 1

Id Name Grade
1 Tom C
2 Sally D
3 John B
4 Alan C
5 Lee A

Class 2

Id Name Grade
1 Nick C
2 Lauren A
3 Dave A
4 Sam A
5 Daniel A
6 Jo B
7 Lisa E

Class 3

Id Name Grade
1 Jack A
2 Jacob A
3 Milly A

What I want to copy is the everything from the row with the headers (Id, name and Grade) in worksheet 1, down until it finds a empty row. When it finds an empty row, i want to copy that data into worksheet 2, insert a page break after the copied data and then copy the next section of data and so on until there is no more data to copy.

I think I can insert the page breaks easily enough and the formatting of the new sheet is already done.

It is just basically a copy and paste but only the data that i need.