Hello all,

This is my first post as I am new to this forum. The problem I am currently having is attempting to build a workbook that has a master sheet with 3 supplementmal sheets feeding it. What I'm hoping to accomplish is that whenever the supplemental sheets are updated, they feed into the master sheet (all of the columns in the master and supplemental sheets are the same) that I am using with a pivot table to show statistics for my company. I've tried all sorts of macros that copy & paste the tables, but I run into issues with re-posting the same data or overwriting certain rows if the supplemental tables are manipulated after I create the macro.

Also, I am trying to exclude certain rows when I print based of a cell value in one of the columns "Closed." I can't figure out a way to do this just because more data is constantly added to these tables so there is not a specific set range for cells containing the word "Closed." I have a macro that autofilters all the rows with "Closed" in column J to filter to the top of the spreadsheet but I get stuck from there.

Sorry if this is confusing, let me know if any clarification is needed. I would post the file, but unfortunately it contains confidential company data.

Thank you for the help.