Hi,
I am new to VBA, and don't know syntax of VBA at all, but I can understand some programming logic like loops etc. I only know how to record a macro.

I have 45 survey results in a template. The data is not arranged into a neat column on this template, but I figure I can reference the same cell location in each respective next sheet.

Now, on column A, I have started a master table which includes the questions down the column.

In columns [B] through [B + 44 other worksheets], I want to populate:

The sheet name in the first row.
The the related data to the questions from the sheet down the column.
[Note: I recorded a macro which would reference cells and put it into the right position in one column for one worksheet.]

Part 2 of the question is that, some of the survey results are in turkish. If the data from a column is turkish, I have seen some macros which can covert via google translations turkish results into english--is it possible to get all the results from the sheet we created turned into english via the translate macro (which may be simple if the macro functions like an excel formula)

Can someone please help?
Sample.xlsm
GoogleTranslate.xlsm