Hi Jan,

To reference a named range on another sheet in your workbook, you can use the following formula:

In your case, if you want to reference the Bills named range on the Jan sheet, the formula would be:

To make this formula dynamic so that it only shows data for the current month, you can use the MONTH and TODAY functions. Here's an example formula for the Bills named range on the Jan sheet that will only show data if the current month is January or February:

1. Formula:

   =IF(MONTH(TODAY())<=2,Jan!Bills,0) 


You can then copy this formula to the other monthly sheets and change the sheet name as needed.

On your YTD Summary sheet, you can use a similar formula to sum up the Bills data from each monthly sheet. Here's an example formula for the Bills YTD total that will sum up the Bills data from January to the current month:

1. Formula:

   =SUM(Jan!Bills:INDIRECT(TEXT(TODAY(),"mmm")&"!Bills")) 


This formula uses the INDIRECT function to dynamically reference the named range on the current month's sheet based on the current date. The TEXT function is used to convert the current date to the month name, which is then concatenated with the !Bills named range to create the full reference.