Creating a Dashboard with Multiple Excel Sheets and Workbooks

[LoneRanger]

Greetings,

I have multiple excel workbooks with the same sheet called "board" which contains 4 Columns and "X" number of rows depending on how many events there are. For example Sally, Jesse, James, Wanda, and Peter each have an excel workbook with a sheet called "board" . Each "board" sheet format is very similar with 4 columns with "x" number of rows depending on each one's events. Some may have from row 1 to 22 or maybe 1 to 50. What I would like to do is import each board into one excel workbook with the first Column A,B,C,D give a column space then copy the next along side of it. Ultimately creating a type of dashboard feel.

Workbook names:

Sally
Jesse
James
Wanda
Peter

 

[LoneRanger]

*bump* Hope I don't get in trouble... If this is wrong please let me know.

 

[ask2tsp]

Are events identified somehow? A datetime stamp or a event type or a sequence number or something else or a combination?

I propose to collect all the workbooks in one list having columns name, event id,a,b,c and d. Then report using a pivot table.