Macro for specific worksheets

Hi

I'm trying to amend my macro to only get data from a specific worksheet in multiple workbooks in a specific folder.

I have very basic knowledge so am lost with it.

This is the first bit of my code which currently means all worksheets in all workbooks are accessed rather than "sheet 1" which is all I want.

Any help much appreciated.

Sub allworkbooks()
Dim MySummary As Workbook
Dim MySummarySheet As Worksheet
Dim ThisSheet As Worksheet
Dim Thisbook As String
Dim SumRowCt As Long
Dim MyPath As String
On Error Resume Next
MyPath = "c:\Users\Claire\"