MACRO HELP - Need to update a cell with data from a list in another sheet

Hi Guys,

this probably has been done before but i cant find it in the forums.

I currently have an excel sheet with a macro which collates the sum of an item for each employee. Additionally this item name is currently manually entered into a cell within the sheet.

What i would like to do is set a macro which looks at a second sheet, pulls the first item from the list to populate the cell, runs the current "collation" macro and then goes to the next item on the 2nd sheet and so on till the last item on the 2nd sheet.

Also the list of items will be different lengths depending on the month, so it needs to understand where to start and stop the list.

Sorry if the above is vague, but thanks in advance

Ok i have uploaded a sample sheet which hopefully makes it a little clearer.

basically i need a macro/VBA which will go to Sheet 2(Samples) and take the value in A2 and populate cell G2 (the yellow cell in this example). <another macro will then run> then it needs to grab the value in A3 and update cell G2, etc etc till the end of the list in the Samples sheet.

The data in green is based on the value in the yellow cell (although in this example ive removed the formula)

thanks

bumping post
thanks