Merge and Order Data From Two Sheets

Hi,

I am looking for a little help with merging and sorting some data.

Currently I have two sheets linked to SQL databases. They are pulling through sales order information, one has the header info (variable number of lines due to version), one has the line info (variable number of lines per order); unfortunately they are in separate tables and so cannot be pulled through together.

My ideal scenario is to do the following:

On the actual data sheets, to the right of the data I will copy the relevant information I need from the mass data (using =). So on both sheets I will end up with the same number of columns, with the same column headings.

Then what I would like is to take the data from both sets and combine them into one dataset on a third sheet, which also sorts them by the order number (each order has its own unique number). So I will then end up with the header of the order followed by the lines of the order.

It would be even better if it could auto-group the lines with the single line from the header (the latest version (there is a version column with ascending number series)) every hour, so the third data sheet would need to reflect any changes.

Is any of this possible, and if so I would really appreciate any help in doing this. I am using Excel 2010.

Many thanks

Matt