How can pull data from multiple excel files?

In my project i'm told to take data from 720 excel files. Each excel files has multiple sheets. I need one particular data from each of the excel files.

Answer 1

[dpb]

<read-a-sequence-of-spreadsheet-files> illustrates use of <datastore>

Answer 2

[Image Analyst]

Since this is one of the most common FAQs, see the FAQ for a thorough discussion:

https://matlab.fandom.com/wiki/FAQ#How_can_I_process_a_sequence_of_files.3F

Inside the for loop over your 720 files, put a call to readmatrix, readcell, or readtable.