Hello. Can someone tell me how I can open multiple files so that they
open in a single workbook, but each file becomes a separate worksheet
within that single workbook? Is there a way to do this? Does it require
using VBA?

Thanks,

Andy