Attempting to Add Column with Corresponding Sheet

Welcome to the forum!

Off the bat, there are two quick issues that jump out at me. First, your For-Next loop runs from a=1 to a=LastColumn, but the moment you hit a Skymaster and insert a column to the right, then the LastColumn in your loop is no longer the actual LastColumn. In cases like this, it's usually smarter to move from a=LastColumn to a=1 using Step -1, so that you're moving backwards through the columns and inserting columns behind the direction of your loop. Secondly, you're only adding worksheets after the loop is complete, so if there are multiple Skymaster entries, it doesn't look like you'd currently be adding multiple sheets.

More importantly, perhaps, diagnosing and updating code by sight and with incomplete context is inexact and inefficient. The best way to get useful help is to attach a small sample workbook (use Go Advanced > Manage Attachments to open the uploader). Make sure you remove any private data. Using an attachment, we should be much better able to see what the error is pointing to and what the procedure is/isn't doing as intended.

Format Note: We also have a rule about using CODE tags when posting chunks of VBA. Could you please edit your post, select the text that comprises the VBA procedure, and click on the hashtag/pound/# icon to wrap the selected text in code tags? Thanks!