Help with sumifs formula across multiple tabs

I have several worksheets in a workbook that have data on them. I want to create a summary tab for those worksheets but I can't seem to figure it out.

Each worksheet contains a date and amount for each lease per contract.
I would like to be able to summarize this information for each month since the dates go across more than one month.

For example, on the summary tab, I would like to be able to put 12/1/17 for the start date and 12/31/17 for the end date and capture the revenue data for the month. I attached an example workbook so maybe you can help??

I want to do a sumproduct formula with a name range but I can't get it to work with the sumifs option.

is this similar to that what you want?

you can choose year or month or unit or all together like exemple

Yes! This is what I was thinking about but I couldn't get it to work. Thank you!!

I would rather use the second option since there are a lot more tabs involved than just the 3 I used for an example (and we will be adding tabs and removing tabs as we go along).

And thank you for welcoming me to the forum. I don't know why I waited so long to join.

You're welcome. Happy to help.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Sandy, thank you! I was looking at your option. I have never used queries before and it looks awesome! I use pivot tables a lot though...just didn't know queries existed. Can you explain how you did this? I may use it in the future. If it's too much, no worries.