Execute VBA codes across multiple sets of sheets via loop

I have multiple sets of sheets that interact with one another.

For example:
FS_Franch copy pastes values to FS_Franch_CPV
ItemWide_Operator copy pastes values to ItemWide_Operator_CPV
ItemWide copy pastes values to ItemWide_CPV

To clean up my code, I would like to be able to create a loop such that it performs these operations to each pair of sheets. I know in Stata it is possible to write code such as:
"foreach x of varlist FS_Franch ItemWide_Operator". However, I can't seem to find similar loop capabilities in VBA. Could someone please help enlighten me?

Example code across a pair of sheets:

Note: The cells will always remain the same across all pairs of sheets. The only thing that will be different is the name of the sheets. THANKS

Please Login or Register  to view this content.

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

Assuming matched pairs of sheet names, you could store them in a Scripting Dictionary and then call them as you loop through.

The Keys are the unique first values, the Items are the second dimension.

Please Login or Register  to view this content.