Need macro to perform certain actions on many different worksheets

Hi Guru's

I'm looking for a macro that will look for a specific workbook in a specified folder based on a list. I need it to open the workbook, perform certain tasks, save and close. Then look for the next workbook on the list, perform certain tasks, save and close. I have approx. 80 different workbooks. Is this possible?

Open Income Statement - Act vs Bud - CM located in \\ltcgsrv1\Cognos\Cognos Report Output\Deck Reports, hide columns U-AA, hide columns O-Q and hide columns F-I. Save and Close

THEN

Open Revenue by Client Trended - ENG - TTM located in \\ltcgsrv1\Cognos\Cognos Report Output\Deck Reports, hide columns U-AA, hide columns O-Q and hide columns F-I. Save and Close

So On and So On

Thanks

Here's an example of what I'm looking for. The Workbook names will be listed in the workbook which contains the macro. I want the macro to look for the workbook name and then perform certain tasks depending on which column the workbook name is located. I don't even know if this is possible and I'm up for any other suggestion on how to perform these tasks.

A B C
A-Name 1 B-Name 1 C-Name 1
A-Name 2 B-Name 2 C-Name 2
A-Name 3 B-Name 3 C-Name 3

If Workbook name is located in column A then Open, hide columns U-AA, F-I and B-D. Save and Close

If Workbook name is located in column B then Open, hide columns U-T, O-Q and F-I. Save and Close

If Workbook name is located in column C then Open, hide columns U-T, O-Q and F-I. Save and Close