Macros for consolidating Data from Different excel Sheets into a new summary sheet

Hey Gurus,

I know nothing about Macros but I need to automate my spreadsheet somewhat to help me work better
I want to do several things but I will start with the first two.

1. I have a main sheet with macros which consolidates info from templates.
But now I wish to make a new consolidating sheet which I will now call the 'super main sheet', which will now be able to consolidate data from different main sheets. This new main sheet is essentially a gantt chart with additional info.
The aim is that I can also distribute the main sheets to my collegues and be able to consolidate the data using the main sheet and not only the templates.
For now the program works well with the templates and I want to preserve it as well.

2. I also wish to modify the main sheet such that I can use it to distribute tasks. so I can fill out the main sheet, send it to my colleagues, they can fill a cell on the rows containing the desired tasks and automatically transport the task to their main sheets while deleting the tasks from the sheet I sent to them. This way there are no double entries for the same tasks.
Then afterwards I can use my super main sheet to consolidate the info.

I will stop at these first two and I hope I explained it well here but I would elaborate more if you need me to.

I have attached the files.

I appreciate your time and effort.

Rgds,
Winterfell

xoxo... its a lovely day in London today .. I should be outside lol

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

Please go to the Commercial Services section of this site http://www.excelforum.com/commercial-services/
And read the FAQ on how to solicit paid help.

Hi Ben

About 1.5 million hits is a bad Title?

I don't pretend to know what the OP requires but the Thread Title is pretty descriptive for a Google Search...

2016-05-07_14-58-00.jpg

Hi winterfell

The Thread is not "locked" as such...modifying the Title to an "acceptable" Title will effectively "unlock" it. Ben describes in his post how to change the Thread Title. Make sure it describes your issue.

Hi winterfell

If you look at your last Post and at this Post you'll see that the Thread Title has changed. Good hunting...