Import 2 different sheets after formatting then replace data

In my workbook "Floor Captain Role" on sheet "Controls" I have a button that I have that says Update IF Arrivals. When I press this button I would like for it to open a workbook called "ContainerArrivalReport" located on my server at (F:\Call Center\Harrison\Rays\IF-Arrivals) then I need it to do these steps:
Delete Column "E"
Delete Column "E" again
Delete Column "F"
Unhide columns "F-K"
Delete row #1 & #2
Cut column "E" and insert the cut cells to column "G"
Cut column "B" and insert the cut cells to column "G"

After that is completed then remove any rows that have a blank in the first column then copy all of that information to the sheet in workbook Floor captain role onto sheet "IFContainers" starting at A7. After that is copied I need it to open workbook "ContainerETAReport" located at (F:\Call Center\Harrison\Rays\IF-Arrivals) and copy everything from A3 down to the bottom (which will change daily depending on how many we have) and insert that copied info to the "IFContainers" sheet in the workbook Floor Captain Role under the last line of the previous information.

After all the data is collected I need to find and replace the following:
CMP - COMPLETED
AVL - AVAILABLE
PLN - PLANNED
DSP - TRANSIT
STD - TRANSIT

After all of that have the macro close all open books except the one called Floor Captain Role. Then save the sheet "IFContainers" as "IFContainerArrival" at the following location (F:\Policies Procedures and Forms\Call Center)

I have attached all my documents so you will be able to see everything I am working with. I greatly appropriate any help with this!!! If there are any questions please do not hesitate to contact me directly!!!

this is untested, so I strongly suggest that you make copies of your files and test it before applying it to your original files.

Please Login or Register  to view this content.

So basically I need the columns to line up out of the "ContainerArrivalReport" to line up with the columns in "IFContainers" sheet. Deleting column E will not affect the data from the 1st step, then when you cut & insert the cut cells it moves the data to the left, so when you cut column B and insert into column G - it moves to the left & the data that was in column B will now be in G.

Also once we save the sheet for the last process, is there a way it can have a password automatically put onto that file?

correct so when the file that is saved is opened, it will require the password! Thank you for all your help!

So my end result should look like this file. Also its not a password to open the file, but a password to allow modifications.

You can probably fix that by changing this

Please Login or Register  to view this content.

to this

Please Login or Register  to view this content.

I think that your suggestion saves the entire workbook with the new name which includes the "Control" sheet.

If the declarations and set statement in the code are correct, it should only create a new workbook with only the IFContainers worksheet in it. Much easier than building in increments. But it was only a suggestion.

Were you able to figure out how to put the password on the sheet? Or maybe we can have the IFArrivals sheet open from that location, copy everything over & then save & close?

So after the file saves for the IFContainerArrivals, it needs to have a password so it can not be modified once it is closed.

This is the current code that I have you helped me with:

Please Login or Register  to view this content.

So after the workbook is copied, I need the workbook to have a password to modify it.

Perfect - thank you so much for your help!

So after working with this code for a while, I realized there is bit of an issue. Our associates are not able to search by container # while the sheet is locked. Is there a way we can make it keep the filters from row 6 or instead of password protected, put a password to not modify?