Hi.. m getting shifted to an apartment in a couple of months.. can anyone please help me the generator load required to run 6 houses of an apartment and the approximate fuel consumption for the same on hourly basis...

What is being assumed for usage per unit? Everything depends on an average load and that can vary a great deal depending on what are unknowns based on the information you provided.

Like Utilities? Natural Gas? All Electric... is this in Phoenix AZ in summer, or Calcutta India. There is a HUGE possible variance on unknown factors.