Excel Data Extraction and sorting

Hello again to all yee gurus!

So i have the following issue. I have several workbooks with lots of data. It goes like this in columns:
ID;Name;Budget;Qnty;PP;SP

Each work book is a month. The workbooks hve lot of repetitive data throughout as the products sold are mostly the same through out the months. Some of the data is not repeated across the rest of the workbooks i.e. unique ids used once through out the year. All workbooks only have one worksheet.

So i was thinking of merging all workbooks into one under different sheet names. So for example if we have the following workbooks August, September, October. We get one workbook "Data" and which will have worksheets August, September, October. SO thats the easy part =)

The hard part:
What i want i a "master" worksheet which combines all the data into one in the following manner.
worksheet data.png

So it goes through all the other worksheets, uses ids form the first worksheet "August" and uses the name of the month from the name of the first worksheet "August" for cell fgh 1 in "master" sheet. it then moves to the next sheet, "September", creates new column ijk 1 and looks for similar IDs fills out the data for the rest of the sheet "Master" . If there are any new IDs it appends them at the end. It then moves to the next sheet, "October", creates new column LMN 1 and looks for similar IDs fills out the data for the rest of the sheet "Master". If there are any new IDs it appends them at the end.

My question is: How in gods name can i do that? Do i need a macro? Where do i start?

Appreciate any of your help! =)

P.S. don't mind the id numbers all being 1. They should all be unique.

Humbly yours,
defy

Post an example workbook - not a picture of one.

Pete

Hi defy
Believe it or not this is relatively simple to do. Once you have copied all your workbooks onto separate worksheets named after the months you can use a VLOOKUP formula. Have a look at the sample I have provided, you should be able to work out what the VLOOKUP formula does. If you need any further help then come back to the forum.
Tony