Populate a list of data from specific worksheets

Hey there,

I've been plugging my way through some VBA and hit a dead end. I have a userform that populates the "Data Summary" worksheet with the inputs from the form and also creates worksheets using the WSC ID.

I would like to pull data from the worksheets using their respective WSC ID. For example, I would like to populate the rows of 08HA002 and 08HA003 with the value from cell I86 in each worksheet.

I've attached the spreadsheet which should help make some sense.

Thanks!

This would read the values from I86 and put it in column G

Please Login or Register  to view this content.

This would put a formula in the "G" cell that would pull the value

Please Login or Register  to view this content.