If first part of file name matches file in folder returns 1 or 0 in spreadsheet

I want to search for files based off of a range of cells with the beginning of the file name.

I would then like for the macro to return a 1 or 0 next to the file name if it is present or not.

My sheet is set up with files names in A2:A29 and I would like to return 1 and 0 for files being present or not in B2:B29

I have started trying to write the macro but I am stuck. Please help

Sub SiteSignal()

Dim folderPath As String
Dim Filename As Range
folderPath = "C:\Users\RobEi\Documents\MWAM_Eisenrich\Client_Data\Sacramento\Sacramento_Flow_Pressure"
Filename = ("A2:A29")

End Sub