Question about using variables for worksheets

[moradisndat]

I was hoping to get a confirmation if I am doing this correctly. (Using variable to refer to sheet)

After importing a large CSV file to sheet1, several actions are performed, mostly using "range." (Delete rows with blank cells, formatting, inserting columns for formulas, assigning named ranges, etc)

It looks like this:
---------------------
Dim ws as worksheet
Set ws = ActiveWorkbook.Sheets(Sheet1)

With ws
.Range("E1").EntireColumn.Insert
.Range("A1:G3").Columns.AutoFit
' and so on
End with
-----------------------

Also, could I use ws in place of using Sheets(Sheet1) to import the file?

With ws.QueryTables.Add(Connection:= _
"TEXT;" & path, Destination:=Range("$A$1"))

Kinda new to this so appreciate any help. Thanks in advance.

 

[MARK858]

If in the below Sheet1 is the sheet name as it appears on the sheet tab then Sheet1 should be in quotes

Set ws = ActiveWorkbook.Sheets(Sheet1)

The rest looks fine.

 

[moradisndat]

If in the below Sheet1 is the sheet name as it appears on the sheet tab then Sheet1 should be in quotes

Set ws = ActiveWorkbook.Sheets(Sheet1)

The rest looks fine.

Thank so much