Hi, I met with some vba coding problem with my project. Pls help me if you can resolve it. Thank you!

1. I need to run userform in one workbook and the data must be transfered to another workbook's sheet. How do I do it?
2. My file is 3MB and it runs really slow in automatic mode but I need the automatic mode to update all my data. So how can I reduce the loading and calculating time?
3. How can I automatically close my userform after clicking on the msgbox that pop up?
4. Is it possible not to activate the userform at the sheet that it is going to input data?