I'm a newbie to VBA and I'm trying to write a macro hopefully some of guys
can help me out.

In this spreadsheet, I would have two worksheets: The main sheet (sheet 1),
and the sheet that only has a list of numbers (sheet 2).

Sheet 2 has a list of about 25 numbers going down column A ie: A1= 45100 ,
A2=45200, A3=64250, etc...

When I execute this macro, what it would do is go to cell B5 of Sheet 1,
then place the first value of the list of numbers from Sheet 2 into B5(Sheet
1), then perform a manual calculation (F9 key), and save the file with
filename of the text value in B5. After the save, it would loop back again
and advance to the 2nd value of the list of numbers..etc.. until the end of
the list.

I would greatly appreciate if anyone could help me with this task.