combine cells in rows

[BillH80]

I have a spreadsheet with 6 columns and unlimited rows.  The rows in the first column contain formulas that bring in data from another worksheet.  Per below cut:

The first column (Project) second row (the home depot) data comes from another work sheet and gets sorted.  I want the remainder of the data in each row to sort with the 1st column info?  Suggestions?

[#2]

@BillH80 Start by deleting empty rows (like the one between the header and the first row with data) and columns in your data (like the two before the due date). Then, you can sort any column of your choice and the other columns will follow. More about sorting in the link below:

https://support.microsoft.com/en-us/office/sort-data-in-a-range-or-table-62d0b95d-2a90-4610-a6ae-2e5... 

[#3]

@Riny_van_EekelenThanks for the reply but not sure it fixes my problem.  I have attached the form I am using that has some notes on it.  Maybe this will clarify what I am doing?

[#4]

@BillH80 

[#5]

@BillH80 Sorry, but pictures aren't very helpful. Difficult to judge how "the other worksheet" influences what you want to achieve.

[#6]

@Riny_van_EekelenOk, I have attached the file.  The sheet "To Do" is the one I need to fix.  The rows in Column A are formulated to sort in the same order as column D in sheet "Sheet 1".  When I manually sort sheet 1 it rearranges To Do sheet Column A to match.  I want the info in column B through H to stay with the name in column A.  Help?

[#7]

@BillH80 Thanks for uploading the file. You are asking for trouble in this set-up. Why not enter the To Do comments in Sheet1 directly. And, I would recommend to clean-up Sheet1 as well. Delete row 2, add a header column P, R, S and get rid of column T.