I sincerely apologize if this has been covered before. I've been searching the Internet for a while but I'm not finding the answer and I think I'm not quite sure how to ask in the search engines to find what I'm looking for.

Here is what I would like to have;
On one sheet (Tasks) in a spreadsheet, I am listing out a timeline of tasks needed to complete a project. The Phase label is in column A while the tasks and subtasks are entered into columns B and C on their own rows (I like to have the widths of columns A and B small (~15 pixels) so that they are indented below each other to show a hierarchy). Associated with each of these tasks and subtasks are start and end dates in columns D and E. I also have another sheet (Timeline) in this spreadsheet which represents the tasks in a graphical timeline-like format. I would like to have the same entries in columns A - E from the Tasks sheet 'copied' to the Timeline Sheet with the same indention format.

Here's what happens;
So the method by which I tried to 'copy' the cell data from one sheet to the other was to use this function on the cells; IF(IsBlank(Tasks!A2),"",Tasks!A2). This works that it ensures that the cell in the Timeline sheet remains 'blank', but it can really mess up the indenting thing I have going on because the cell truly isn't blank and therefore if something is entered in column B, column C with this formula takes precedence and B gets cut off. In my searches, I've learned that a formula cannot return an empty cell AND I've also learned that the fact of a formula existing in the cell will cause this problem, as well.

So, if I've what I've explained above makes any sense and someone has a way of making this work, I would really like to know it. Otherwise, I'll just manually update both lists and move on.

I do appreciate any help in advance. Thank you!

Greg