I have about 100 excel spreadsheets with one line of information in the top
row on the first sheet in a folder. I need to copy the one line from each
workbook and put them in another workbook all on the same sheet in different
rows. Is there anyway to automate this?

Thanks for any help.