Search Different Workbook For Sheet Name

I have two workbooks, WorkbookA and WorkbookB. Consider WorkbookA as the "summary" workbook where all of the data is presented in a simple manner. WorkbookB has about 100 worksheets (with each worksheet referring to a specfic job number ex. 1234). All of the sheet names of WorkbookB are listed in cells A1-A100 of WorkbookA.

I need a way to do the following:

1. While in WorkbookA, search WorkbookB for worksheet "A1"

2. After the correct worksheet is displayed in WorkbookB, I will be doing a series of vlookups in order to gather the data.

3. Repeat steps 1 and 2 for all 100 job numbers (cells A1-A100)

how I can achieve step number 1, I'd really apreciate it. I created a macro in the past to search WITHIN a workbook for a specific sheet, but I've never made one to search thru another workbook based on a specific cell value. The code I used to search within a workbook is shown below.

PHP Code:

Sub GetSheet()
Dim SearchData As String
SearchData = InputBox("Enter assembly number (including group)")
If SearchData <> vbNullString Then
On Error Resume Next
Sheets(SearchData).Activate
If Err.Number <> 0 Then MsgBox "Unable to find sheet named: " & SearchData
On Error GoTo 0
End If
End Sub