This vba macro is for pulling csv files from a directory and working them. It is set up to only pull the current days files. The csv files are all combined into one xlsx file named with today's date. The file is reworked using delimited options and sheets are all renamed based on what the file contains.
Next, spreadsheet A is opened and the needed infomation is pasted. The original files are saved and closed.

Feel free to copy and edit for your own use.

This code was created by Justin Pursley.