Click Through Messages While The Macro Is Running

I have set up a macro that opens a set of about 20 excel files, one at a time,and then copies select sheets, and then pastes into a different main spreadsheet. After each sheet is opened and copied/pasted, I close it out and open the next one. My problem is I keep having to click through messages while the macro is running. I encounter the following messages:

1. Do you want to save (file that I opened and copied from)?

2. The formula or sheet that you want to copy contains the name "asdf.." which already exists on the destination worksheet. Do you want to use this version of the name?

3. A box comes up that says update values from this file:

4. There is a large amount of information on the clipboard. Do you want to be able to post this information into the clipboard later?

I would rather ignore all of these message boxes, but my answers to them are as follows:
1. No i do not want to save
2. Yes I want to use that version of the name
3. I want to select cancel out of this
4. No i do not want to be able to post that information.

Is there any way I can automate this?