Macro to format numerous sheets into one

Hi

I was wondering if anyone could help with the below:

I currently receive a file on a daily basis, which appears in the same format each day.
The problem I have is that the workbook contains a different number of sheets each day and each sheet contains a different number of orders.

Some days there can be 1 order and only 1 sheet. Other days there can be 20 orders and on 15 seperate sheets. (see spreadsheet Example)
(Note that sometimes the sheets do not go up in numerical order, for example this example the sheets are numbers 1, 6, 9 and 16.

What I want to do is format the spreadsheet "Example" into something similar to the spreadsheet "Example1" that ive attached.

Basically "Example1" has had columns E & G added in and this information is populated from cells B1 and C12 on the relevant sheet

(Note each sheet can have different dates in C12 and Buy/Sell indicators in B1)

Can anyone help or point me in the right direction?

Regards

If you search my recent replies I posted similar code in the last few days.

Originally Posted by royUK

If you search my recent replies I posted similar code in the last few days.

Roy,

Ive just had a search through your recent posts and cant find it.

Can you please point me in the right direction?

Cheers

McCrimmon