HI Ron have been playing around whit your mastersheet macros but am
failing to try and adapt you awsome work to do what I want to do was
wondering maybe if you could help. I have built a order shett for use
inside my company and have 5 deparments to which I have given excel
based order forms then I have a master on my computers where I have 5
tabs which copy the link from each page.Then I have a six tab which is
my master in this master I want to copy all the ordered product from
the five tabs so Your second Macro Is great as I can copy from a
specific row but dont no how to copy a specific range if there is
information in the cells also want to copy it in a defined are so it
still looks like an order form. I will edevour to play around with
your great work if you are able to point me in the right direction
would be great

kind regards
James