hi, i would like to merge some data from 100+ excel files into 1.

all the data are saved in different files and saved on the same folder (name: 0001.xls, 0002.xls, 0003.xls... etc) needed data are in the same field (eg. from B4:B8)

and i need the data to be put into 1 single sheet in collum. (i.e: collum A put data from B4, collum B put data from B5.....)

how can i do so?

i totally have no idea on VB... i googled abit but cant find a sutitle marco to help me with it.

pls help! thanks!