Conversion sheets to flat file

I have an excel worksheet with 28 sheets, showing daily results of movie titles. I need to create a single flat file. This requires some data conversion. The format of the source worksheets is not consistent. A full example is attached, with detail of the final format of my flat file. This example shows only one out of the 28 sheets, which I will deliver upon acceptance of the bid. Note that these 28 sheets are of the same length. Serious bidders only, indeed: - this project must be completed in 5 days, and I won't accept postponements. I also expect daily deliverables. You can use some macro functions or do the entry manually. It should not take more than one working day for manual entry. - I will do some test to ensure the accuracy of the entry - errors demonstrating negligence in this work will lead to arbitration. ## Deliverables One flat Excel file, with one single worksheet following the format of the attached Deliverables file - fully accurate. ## Platform Excel Windows