Macro to transfer data submitted on monthly tabs into a table on a separate tab

Hi,

I receive expenditure submissions from a number of departments on a monthly basis. I'd like to create a macro that copy's the data that is contained on each monthly tab onto a separate tab.

Attached is an example of the data I'm working with. Basically I would like the data on the 'Apr', 'May' and 'Jun' tabs copying onto the 'Data' tab to populate the table in the format presented there.

If you have any queries just give me a shout.

Thanks in advance,

Snook