How do you create three dimensional arrays and assign their values from mult worksheets?

[Vastin]

Hi all,

I'm a beginner in excel VBA and I would like to know if you can help me start creating my macro. Here's the context of the problem:

Assume an automotive manufacturing plant that has 4 different lines to create 4 different vehicles. Each line has their own key performance indicators. Each worksheet represents different line by week. The desired output would be graphs showing the performance of each line by week. What I imagine is a dynamic graph with a drop-down list to change the line, where y-axis is the OEE and the x-axis is weekly OEE.

I assume that this would require a three dimensional array (Line x, performance indicator y, week z) and some of these inputs would come from the worksheet name that might or might not be standardize. I attach the sample of the input and I would really appreciate if you have any input.

Thanks!