Trying to combine information from multiple sheets into a new workbook

[dollarbill1979]

I work in construction and have created a scheduling template for each of my properties. I would like to create another workbook with tabs for each of the contractors that will pull the job name, task, and start/end dates for each job in the original file. Attached is the original and my idea of the new spreadsheet. I have moved certain columns around to make Vlookup easier but I am not sure how to a. make it easily updateable and b. not use VBA as most of my contractors' servers will not allow it, although the solution to this will just to save the new spreadsheet as a .pdf before sending it out.

Thanks for the help/advice.

[alansidman]

Based upon your attached file, I assume that you are no longer using XL2003. Please update your profile to indicate the Version you are using. This makes a BIG difference in the solution offered as there are many newer features available in newer versions of excel.