Loop through tabs and return date and amount when amount is present

I have a workbook with a tab for each month dating back to 2011. I need to pull the date and dollar amount each time column "J" has an amount in it, not including the "Totals" line at the bottom of each month. How do I do this?

I've included a "Example Result" tab along with three sample tabs on the report. I'll be adding a new tab every month so I need to be able to keep it updated as time goes by.

I'm working to learn VBA and I know I need to set up a loop to go through each worksheet and look for a value in column J that has a number value -9 columns over(this would help omit the "Totals" value at the bottom of each page) and return the value of the two columns(Date and VMI Invoices), plus the worksheet name that it was found on(worksheet name is used so I know what year the results are from....there might be an easier way to pull the year but I don't know of one).

Thanks for your help.

This will work, thanks for your help.

This does return the "Totals" and other row that have something in column J but I can filter out those.

This will save a ton of time, thank you!