I want to create a list using the concatenate function in Excel 2007. (Or
another method if something else works better.) The list I'm creating is
code that will be copied and pasted into CADD software that will
automatically number plan sheets.

What I can't figure out is how to properly combine the lines of code
together with the list of sheets. What I need to do is combine four lines of
code with each sheet in a list of plan sheets. The lines of code are as
follows:

MbeSetAppVariable "CHNGTXT", "chTextInfo.oldString",
MbeSetAppVariable "CHNGTXT", "chTextInfo.newString",
MbeSendCommand "CHANGE TEXT ALL "

What I need to do is combine these lines of code (with one blank line after
the three lines) with a list of plan sheets.

Combine these lines:

MbeSetAppVariable "CHNGTXT", "chTextInfo.oldString",
MbeSetAppVariable "CHNGTXT", "chTextInfo.newString",
MbeSendCommand "CHANGE TEXT ALL "

With this list:

Tile Sheet
Table of Contents
Shematic Plan
Notes

As an example:

MbeSetAppVariable "CHNGTXT", "chTextInfo.oldString", "Title Sheet"
MbeSetAppVariable "CHNGTXT", "chTextInfo.newString", "1"
MbeSendCommand "CHANGE TEXT ALL "

MbeSetAppVariable "CHNGTXT", "chTextInfo.oldString", "Table of Contents"
MbeSetAppVariable "CHNGTXT", "chTextInfo.newString", "2"
MbeSendCommand "CHANGE TEXT ALL "

MbeSetAppVariable "CHNGTXT", "chTextInfo.oldString", "Schematic"
MbeSetAppVariable "CHNGTXT", "chTextInfo.newString", "3"
MbeSendCommand "CHANGE TEXT ALL "

MbeSetAppVariable "CHNGTXT", "chTextInfo.oldString", "Notes"
MbeSetAppVariable "CHNGTXT", "chTextInfo.newString", "4"
MbeSendCommand "CHANGE TEXT ALL "

However, when I use the concatenate function and copy it, it skips every
four lines. What I get is:

MbeSetAppVariable "CHNGTXT", "chTextInfo.oldString", "Title Sheet"
MbeSetAppVariable "CHNGTXT", "chTextInfo.newString", "1"
MbeSendCommand "CHANGE TEXT ALL "

MbeSetAppVariable "CHNGTXT", "chTextInfo.oldString", "Notes"
MbeSetAppVariable "CHNGTXT", "chTextInfo.newString", "4"
MbeSendCommand "CHANGE TEXT ALL "

How can I combine the lines of code with my list of plan sheets so that it
doesn't skip every four lines?