Close workbook whose name is different each day.

Yes it matters, a lot.

Try this, it converts both the worksheet name and what we are looking for to upper case, so case shouldn't be an issue.

For Each wb In Application.Workbooks
   If UCase(wb.Name) Like UCase("Storage_Trending_*") Then
      wb.Close SaveChanges:=False
      Exit For
   End If
Next wb