I was wondering if I had to open up a workbook in order to extract data,
filter, sort, delete rows etc.?

I already use the workbook().Worksheets() notation to deal with open
workbooks.