I currently have about 10 pivot tables pulling from a sheet named "Data Pull". What I am trying to do is create a macro that will format the drill down data in the same format as the "data pull" sheet (with format painter or w/e), then move this sheet into its own workbook and minimize it as a smaller window, so it seems like a pop up in a way. Is there any way to accomplish this? Thanks!!!