Help merging worksheets in shared workbook
 

We are creating a shared workbook to keep track of issues arising within
several projects. Each project will have it's on tab/worksheet within the
workbook. We would like to have a Summary tab/worksheet that will pull
together all of the issues from the other 3 to 4 tabs/worksheets. However, I
can't figure how to do this since in a shared workbook you cannot have a
macro or utilize pivot tables??? Thank You for your help!