I am trying to create a formula that will allow me to sum all the values in a
chart for a certain date. So across 5 sheets, I have a total sheet, and I
want the "January 31st" value in the "completion" column to automatically
update based on the values in "January 31st" under the "completion" column
for the other worksheets. I know this is possible if the cells were the same
- but they are not. Is there a way to create a formula based on searching for
the date name?

Thank you!