In Python, how to put in one Dataframe row, Data scattered in different cells in a sheet [closed]

Solution for In Python, how to put in one Dataframe row, Data scattered in different cells in a sheet [closed]
is Given Below:

I have a sheet which is a Daily Dashboard. The data in the sheet is scattered across the cells and is not in the form of an Excel list or Table. I need to combine different cells and make it into one row in a data frame for each date. (The task is to combine the Daily Dashboard sheet from different workbooks into one consolidated report.)

For example, B2, B3, I11, I14 need to be combined into one row of the dataframe with the date as the index (row header)