I do need some help . . . please. Hope someone can help.

'HERE IS WHAT I NEED AS PART OF MY MACRO . . . . . . . I HAVE AN OPEN
WORKBOOK.
'The name of the active workbook is PacificWindsRentRoll.
xls
'The macro selects . . .
Range("AD100").Select
'In cell AD100, the activecell, is a numeric value . . .
LET'S USE 10 AS OUR EXAMPLE
'I need to open a workbook from folder MyExcel and the
file name is 10.xls
'After the file has been opened, the program needs to re-
activate PacificWindsRentRoll.xls
'Next, the range ("ab100:ao100") needs to be selected and
copied
'The file ( 10.xls ) that we just opened needs to be re-
activated.
'The copied range is then pasted into cell A2 of 10.xls.
'This file 10.xls is then saved and closed.

'The next time this is run, a different file name would be
opened, as the value in cell AD100
'changes.
'My Macro already has a do loop that works and it knows when
to stop.