How do you reference a variable file in VBA?

How can I reference Sheet2 of my opened file?

Currently I have a macro that finds the most recent file in a folder and opens it. If I wanted to do a calculation based on a column in Sheet 2 of the newly opened file, how would I reference this file in VBA? I cannot use the file name to call it since the file name will change (each time I run the macro, the most recent file is opened). For example, if I run the macro this week, the file name "12-7 Reports" is opened, but if I run it next week, the file "12-14 Reports is opened"

You may try like this...

Dim ws As Worksheet
Set ws = ActiveWorkbook.Sheets(2)

Try this...

Dim wb As Workbook, swb As Workbook
Dim ws As Worksheet, sws As Worksheet

Set wb = ThisWorkbook   'wb refers to the macro workbook
Set ws = wb.Sheets(1)   'ws refers to the first sheet of macro workbook

'Once the code opens a workbook
Set swb = ActiveWorkbook 'swb refers to the opened workbook
Set sws = swb.Sheets(2)  'sws refers to the Sheet2 of opened workbook

wb.Activate    'Activating macroworkbook again