Workbooks are files. I suspect you are talking about worksheets.

When you do a Sheets.Add, the new sheet becomes the active sheet.

You can then name it

ActiveSheet.Name = "xxx"

and/or grab a reference  to it

Dim aa as WorkSheet
Set aa = ActiveSheet

Why didn't you post the code you have? And please use a more relevant
subject line for your messages.