I need to create text boxes for lines that have text

Hi,

I have used macros but not VBA. I have been trying a couple days to search for an answer that may already be posted, but I have not been successful so far and am running out of time.

I am using Excel to create an appointment board for our service department. I can export our appointments into Excel so I have the info on a spreadsheet. I need to create text boxes to represent our appointments. I need for each line with text to have a corresponding text box created and populated with info from that line in Excel. The text box should be aligned with the line it corresponds to. It needs to stop creating text boxes when it encounters the first empty line.

Can I also have all those text boxes copied and pasted into another sheet within the same workbook? This would be a separate process from the creation of the text boxes.

I've attached a sample. The Board sheet is what it should look like and the Appointments sheet has the listing of the appointments. I would like the text boxes to be created in the blank columns in the middle between the "Customer" and "SA" columns.

Thank you for any help you may be able to give me.