combine multiple worksheets into one

[kamelkid2]

im dealing with a large number of files, that each contain a large number of worksheets (ive seen up to 60 in a brief look). what i need to do is consolidate each workbook into one, hopefully concise worksheet. it doesnt have to be a perfectly clean breakdown, just something that will allow me to manually clean up each individual file versus each individual worksheet. does anybody have any tips on how to do this?

i have tried various freeware/trial programs that say they will put them into a single worksheet. all have either failed or have put them into one cell with spaces, rather than keep the original integrety (meaning all data in cell a1 as opposed to proper cell range a1 to e1)

im really at a loss and need something more efficient than manually copying each book. anybody got anything? attached is a sample file that i am working on


edit: i alternatively have pdf files from which these were generated if this method would be any more beneficial

[kamelkid2]

http://www.rondebruin.nl/merge.htm

i stumbled upon this. did this AND more than what i wanted - was actually able to put ALL the files with ALL the worksheets into a nice list while maintaining integrity. i highly recommend if anyone has a similar situation to what i have. this just saved me literally hundreds of hours