Ok. Here's my issue.

I have a spreadsheet with 12 monthly tabs and a summary page with current day, month to date, and year to date.

The issue that I am having is the month to date.

I need to pull the month to date totals from each spreadsheet based on the current month.

For example, I would need to pull march's MTD this month.

On April 1st, I would like to pull that MTD

The catch is...i would like for it to be done automatically.

VBA is not my strongsuit. Would a "sumifs" work in this case?

Any help would be great.

-Adrian