Storing work sheets from other Workbook into One Excel work book

[DINAUKAUR]

Dear Mr. Jury,

Please help me for storing all worksheets from Workbooks into One Excell Book.

Thanks and Regards,
DINAUKAUR

 

[ravishankar]

Do you want to collate all worksheets or consolidate data from all books into one sheet?

 

[DINAUKAUR]

I want to collate all worksheets from all books into one sheet

 

[ask2tsp]

All books on your computer or books found in a certain directory?
And if you want to collate all sheets into one, I assume all sheets are formatted the same way?

 

[DINAUKAUR]

Yes,All books on my computer.
And I want to collate all sheets into one, you can assume all sheets are formatted the same way?

.
In some work sheets columns sequence are not in same way.

 

[ask2tsp]

Please tell us why you want all sheets in all workbooks into one sheet. What do you want to do with that sheet?

 

[DINAUKAUR]

Please tell us why you want all sheets in all workbooks into one sheet. What do you want to do with that sheet?

My Objective is "Inventory consolidation". Our branches stocks are came through mail.
After getting mails form sources,I have to consolidate the stocks as two types:
1. For preparing MIS (Management Information system) Higher management consolidation.
2. Each sheet link to be assigned to MIS sheet.