Welcome to this forum Al. U can look here for a general idea.... http://www.vbaexpress.com/forum/show...ighlight=table
You need to be specific... U have 800 Word docs, XL files, or both? Are they all in 1 folder? All data to 1 XL file? What & Where exactly is the data and where exactly do U want to put it? HTH. Dave