Record a macro doing what you want to do. Then you can use the code generated(with any appropriate amendments) to apply to the new imported sheets.