VBA code to copy paste a range based on a condition

HI,

I have a workbook with columns A,B,C, D and E

A3 is program ,B3 is department,C3 is date ,D3 is class and E3 is Subclass.
The data is present only for columns A,B and C i.e it starts from A4 and ends at C25 for the first program

This is followed by headings again in A26,B26,C26,D26 and E26.
again followed by data below them.The range varies from program to program

I want to write a VBA code which copies the first program data into the 2nd tab.
the 2nd program data into the 3rd tab and so on.


Thank you so much in advance.

Example
Program Dept Date class Subclass
055 055 12/03/2013
062 055 20/03/2014
052 055 21/02/2014
Program Dept Date class Subclass
123 071 12/03/2013
156 071 21/02/2014

In this example the first program data needs to be pasted in the second tab and the second program data needs to be pasted in the third tab and so o

The line numbers of data in a particular program could vary