Macro guidance

[BLUFFdisko]

Hi all

im triyng to make what may seem as a simple sheet to many, but though i master prettty bacis things in excel i still cant figure this out, so maybe someone could give a helping hand.

can anybody give me some guidance on how to make marocs, so that i can make sheets like the one on the data sheet found on the ba charting sheet,im trying to make a sheet just like the ba mutiple sheet found on ba site, but just with a data sheet for every market thet plots the data, for a chart

any help will be much appreciatet