Invoice Data Entry & Sorting

I have a batch of invoices already saved in Excel. From each row I need three fields pulled out—Date, Amount, and Vendor Name—and then placed into a clean, consolidated sheet that is chronologically organized. The finished workbook should let me filter or pivot the data by day, week, or month without any manual tweaking.

Please:

• Extract Date, Amount, Vendor Name exactly as they appear in the source files.
• Build a master sheet ordered by date (oldest to newest).
• Preserve original formatting for dates and currency so formulas and summaries work immediately.

I will consider the job complete when I can open the file, scan through a single, duplicate-free list, and run a quick pivot table that groups totals per month without errors. If you prefer using Excel formulas, Power Query, or VBA, let me know—whatever gets it done accurately and quickly is fine by me.