Microsoft Excel Help

[Compnewbie01]

I need to transfer information from a few hundred excel spreadsheets to one single spreadsheet. I am hoping that this is possible and easy to do without having to open each individual file and typing it in manually. Google hasn't been able to help me. Here is a pic to show what I am talking about.

http://img593.imageshack.us/img593/3308/85326238.jpg

I want all the information from the top box to be copied over to the second box/

B3 > A2
B4 > B2
B5 > C2
B6 > D2
etc...

I can enter this all in manually but that would take hours if not days. Is there a way to just quickly import or even give a folder name with ALL spreadsheets to just get opened and entered automatically?

Any help is appreciated.

Thanks

 

[NeoV]

you should go to the mrexcel.com forums

you can do what you are asking - as long as the format of each file is the same, it' really won't be too complicated, but it will involve some VB macro stuff

 

[Jadow]

welcome to the world of shitty data formatting.

whoever designed that first sheet should be shot

 

[Compnewbie01]

That spreadsheet is actually great for what we do. The only reason I need to do this is because I'm receiving a new software and it would help me out if I transferred all customer data into it.

 

[Rackmountsales]

I have heard that we can transfer many excel sheet's data in one.
You need to merge all them into one.

 

[GrumpyMan]

Use ASAP Utilities (Google it). Free for home, cheap license for work. Use the Import feature in the ribbon, there is an Export feature too. If you use Excel often for data manipulation, you should use this addon or at least try it, has many pre-programmed macros.