Loop through of sheets and execute calculations based on dynamic sheet references

Greetings,

Is it possible to loop through a list of sheets and execute some calculations that have sheet references from a different list of worksheets? For example, you have a list (list 1) of your worksheets, which will be the destinations of the calculations, and you have a second list (list 2) of worksheets that the calculations are based on. So, lets say there are sheet1 and sheet2 in list 1, and sheetA and sheetB in list 2. The calculations based on sheetA would appear in sheet1, and calculations based on sheetB would appear in sheet2. I thought the code would look something like this:

Please Login or Register  to view this content.

I'm getting a "Run-time error '1004: Application-defined or object defined error" at this line:

Please Login or Register  to view this content.

Any help is much appreciated.

Regards,

Thanks for the reply Naveed. With this code:

Please Login or Register  to view this content.

I get a run time error 9: subscript out of range. With this code:

Please Login or Register  to view this content.

I get a run time error 13: type mismatch. With this code:

Please Login or Register  to view this content.

I get a run time error 13: type mismatch. Any thoughts as to what could still be going wrong? The worksheet list for list one is A1:A51 and for list 2 is F1:F51. Cell A14 contains a number and not text.

Thanks for you help Naveed. This is the code I was trying to produce.

Please Login or Register  to view this content.