Consolidating worksheets

Hi

Could someone please please help me with the following;
I am needing to do a spreadsheet with 4 different tabs that when you click on a merge button it will automatically transfer all the data to another worksheet labelled Completed. This would include if one of the tabs deletes a line the line will automatically delete off the completed sheet when the merge button is clicked.
ON all sheets they have to be sorted via date descending date order
They all have to have a button which will collate the information.
I need to lock certain columns.
I need to create a print macro button which when clicked will allow the user to print automatically.

Is this possible? I would appreciate any help, even if half of it

Cand, please take a moment to read the forum rules and then amend your thread title to something more descriptive of your problem.

Also, try asking just one question per thread, and be descriptive of your data and layout. Or better yet, upload a sample spreadsheet that also shows your expected results.

Thanks!

Thanks have attached now

hi Cand,

Welcome to the Forum

Ooopps!
You missed part of Paul's request, by amending your thread title (in your first post), you make it easier for people to quickly identify if they can help you & you help in creating a more searchable archive of solved problems.

An example of a more suitable title could be something like "conditional consolidating of separate sheets within a file".

Personally, I would suggest redesigning your file to use a single sheet "database style layout" with an extra column to identify if the item is Complete.

If no one else looks into this before I check again, I may be able to help if you upload another example file which has been saved in compatibility mode for Excel '97-2003 .xls format.

Rob

Hi Candy,

There shouldn't be any need for stress leave around here

Yes, what you've asked is definitely possible - can you please upload your sample file again using the ".xls" format?

Rob