Ok so I have a workbook that I want to consolidate one specific sheet from other workbooks. the sheet is call "Blue Tab". Basically, I want to open multiple files that are arranged exactly the same sheets and everything and take the "Blue Tab" and copy it into the summary workbook. I'm not very proficient with excel, but so far I have gotten to the point where I can open multiple files. Here is the code I have so far. All I care about is just copying the "Blue Tabs" from the multiple workbooks into the same workbook. Thanks!

Sub Test1()
Dim var As Variant, i As Integer
var = Application.GetOpenFilename(, , , , MultiSelect:=True)
On Error GoTo ERRORHANDLER
For i = 1 To UBound(var)
Workbooks.Open (var(i))
Next i
Exit Sub
ERRORHANDLER:
MsgBox "No files were selected, action cancelled."
End Sub