In 2010, Microsoft added yet another technical term—Power Query—to Excel's long list of jargon, but it's not as complex as it sounds. In fact, once you get started, it's not too steep a learning curve ...

Rerun the Import Wizard, this time choosing to append data to your new table and specifying the name of the next file you want to import. Append your data and launch the wizard again for the next ...

The Text Import Wizard can replace existing data in a worksheet when it brings in new text. Use a blank worksheet so you don't risk overwriting your current data.