I'm working on some hypothetical code, but I imagine it will come in handy somewhere down the line. Is it possible to list the names of workbooks and then loop through all the names to perform an action on each?

Let's say I have three workbooks named "Workbook 1", "Workbook 2" and "Workbook 3"

Is there a way I can assign each of those names to a variable, or assign them to an array, and then tell excel to loop through each of them and tell me the name of the workbook in a message box?